Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-17-2022, 06:56 AM
Haha88 Haha88 is offline Extract Text from a text string Windows 8 Extract Text from a text string Office 2010 32bit
Advanced Beginner
Extract Text from a text string
 
Join Date: Mar 2015
Posts: 79
Haha88 is on a distinguished road
Default Extract Text from a text string

Hi,



I'm trying to extract a set of text from a string in excel. However as it's not quite unique, I don't know hot to set up a formula for these. Please can someone help?

I attached the excel sheet. Data is on column A, expected texts to be extracted is in column B.

Much appreciated.

Haha88
Attached Files
File Type: xlsx Extract text.xlsx (10.6 KB, 12 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to extract CCIs as separate entries when part of a text string Cray_Z Word VBA 5 01-13-2021 03:45 PM
Extract Text from a text string Extract Bold text from string one4youman Word VBA 8 04-18-2019 12:31 AM
Formula to Extract text from a text string Haha88 Excel 2 11-14-2017 01:32 AM
Extract Text from a text string Extract text from a text string Haha88 Excel 8 02-13-2017 05:06 PM
Extract numbers from a text string aleale97 Excel 4 02-10-2011 10:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft