Extract Text from a text string

Haha88 · #1 05-17-2022, 06:56 AM

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

Logit · #2 05-17-2022, 10:10 AM

In C4 paste :

Code:

=RIGHT(A4,LEN(A4)-SEARCH("-",A4))

and copy down the column. Now hide column C.

In D4 paste :

Code:

=SUBSTITUTE(C4, ",", "")

and copy down the column.

Column D displays your final result using Column C as a HELPER COLUMN.

Haha88 · #3 05-19-2022, 03:14 AM

Thank you, Logit.
It works its wonder.

Best regards,

Logit · #4 05-19-2022, 08:27 AM

You are welcome.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 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	Haha88	Excel	8	02-13-2017 05:06 PM
Extract numbers from a text string	aleale97	Excel	4	02-10-2011 10:33 AM