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.

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