Shorten string

[Xx7]

I have these on 2 rows

Row 1

[URL=http://img31.imageshack.us/i/bjalskf.jpg/][IMAG]http://img31.imageshack.us/img31/3sfjld/salfdj.jpg[/IMAG]

Row 2

[URL=http://img816.imageshack.us/i/254593ddsf.jpg/][IMAG]http://img816.imageshack.us/img8886/5673/254sdfd55.jpg[/IMAG]

I want to make it

Row 1

[IMAG]http://img31.imageshack.us/img31/3sfjld/salfdj.jpg[/IMAG]

Row 2

[IMAG]http://img816.imageshack.us/img8886/5673/254sdfd55.jpg[/IMAG]

 

[Trebor76]

Hi Xx7,

Try this formula - just change the cell reference (from A2) to suit:

=TRIM(MID(A2,SEARCH("[IMAG]",A2)+6,LEN(A2)-SEARCH("[IMAG]",A2)+6))

This can then be converted to a value and put back to the originating cell.

HTH

Robert

 

[Ron Coderre]

This regular formula returns the right-side text of cell A1, beginning with the [IMAG]:

B1: =MID(A1,SEARCH("[imag]",A1),LEN(A1))

Is that something you can work with?

 

[Xx7]

Nice thank you!!