#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
In C4 paste :
Code:
=RIGHT(A4,LEN(A4)-SEARCH("-",A4)) In D4 paste : Code:
=SUBSTITUTE(C4, ",", "") Column D displays your final result using Column C as a HELPER COLUMN. |
#3
|
|||
|
|||
Thank you, Logit.
It works its wonder. Best regards, |
#4
|
|||
|
|||
You are welcome.
|
Thread Tools | |
Display Modes | |
|
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 |