=trim ???

[BusyEvent]

I've seen this asked on the forum before and I've done some researching, but those questions/answers are more complex than my simple need.

I have a string of characters that I need to 'trim' to the far left and the far right of the desired data.

Example: blahblah.jpg ( https://busyevent.thingy.com/yupyup/...D/blahblah.jpg )

I would like to remove all of the data in bold/red and put the remaining string/URL in the target cell.

Your help is appreciated.

[dilipandey]

Hi BusyEvent,

I am not able to view the link, could you upload the sample workbook. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[JieJenn]

You can use TextToColumns with delimited ( and ). So basically, do TextToColumns twice to capture everything in between ( and )

[scottyboy218]

are they all in this format? whatever.jpg (the stuff you want ) ?

if so, highlight the column of cells, and select Data -> Text to columns. Select delimited, and use "(" (without the quotes) as your delimiter. This will split up your data between two columns (or more if you have multiple "("'s )

Let me know if this helps!

[BusyEvent]

Thanks all...the link is unimportant...all I really need is an =trim formula that will remove the 'red' stuff and paste the remaining url/string into the target cell.

I've tried the data > text but that isn't working.

???

[scottyboy218]

Try this (assuming it's in cell D4). Note that this formula will only work assuming they are all in the same format you provided in original post

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