Hi,



I hope someone can please help to create a formula to extract text from a text string.

Attached an example sheet.

Thank you.

Attached Files

Test.xlsx (9.0 KB, 17 views)

Data - Text to columns - set : as delimiter - do not import unnecessary columns in the wizard's last window

__________________
Using O365 v2503 - 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

does this work?

=MID(C3,FIND("::",C3,1)+2,LEN(C3)-FIND("::",C3,1)-2)

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,

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))))

Did you check to see if you entered your formula as per the suggestion ?

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.

Hi,

This works wonderfully!

Thank you,

Did you, by accident, pay the slightest attention to post #2?

__________________
Using O365 v2503 - 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

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.