#1
|
|||
|
|||
Help with Formula to extracting text from text string
Hi,
I hope someone can please help to create a formula to extract text from a text string. Attached an example sheet. Thank you. |
#2
|
||||
|
||||
Data - Text to columns - set : as delimiter - do not import unnecessary columns in the wizard's last window
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
does this work?
=MID(C3,FIND("::",C3,1)+2,LEN(C3)-FIND("::",C3,1)-2) |
#4
|
|||
|
|||
Hi,
Thank you for looking into this. I tried and the result comes back with #Value! =MID(N29,FIND("::",N29,1)+2,LEN(N29-FIND("::",N29,1)-2)) What has I've done wrong? Thanks, |
#5
|
|||
|
|||
I might have used a sledge hammer...
D3 copied down to D5 =MID(C3,FIND("::",C3,1)+2,LEN(MID(C3,FIND("::",C3, 1)+2,LEN(C3)))-LEN(MID(C3,FIND("@",SUBSTITUTE(C3,":","@",4)),LEN( C3)))) |
#6
|
|||
|
|||
Did you check to see if you entered your formula as per the suggestion ?
|
#7
|
|||
|
|||
removed.
As my suggestion only satisfied the result you show. I suspect Jeffrey is a better mind reader for the results you don't show. |
#8
|
|||
|
|||
Quote:
This works wonderfully! Thank you, |
#9
|
||||
|
||||
Did you, by accident, pay the slightest attention to post #2?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#10
|
|||
|
|||
Oh, apologies! I didn't understand what you tried to tell. U will also try your method, will let you know if it works. Thank you.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Way to search for a string in text file, pull out everything until another string? | omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
Extracting a phone number from a string that contains text and numbers. | hommi16 | Excel | 2 | 06-05-2013 09:19 PM |
Extracting text from a Word Doc into Excel | dgcarlin | Word VBA | 1 | 07-06-2012 05:46 PM |