Excel Help Please - Text String.

Da[]San · 27 May 2008 at 10:37

Hi,

Can anybody help me with this problem in Excel.

I need to return four characters after an _ from a text string, example as :-

DV9675EG_3C07 Galaxy 1.0

I want the formula to return the value 3C07

Can anybody help?

Thanks

|Ric| · 27 May 2008 at 11:08

If A1 contains the value you want to pull out the 4 characters from then:

Code:

=MID(A1, FIND("_", A1)+1, 4)

Da[]San · 27 May 2008 at 11:56

Hi, that works.

Do you happen to know the syntex for this.

Taking the example above, i want to return everything after the "_" and before the " " as i've discovered that the characters are sometimes longer then four. Thanks

|Ric| · 27 May 2008 at 13:08

Fixed

Code:

=MID(A1, FIND("_", A1)+1, FIND(" ",A1, FIND("_", A1)) - FIND("_", A1) - 1)

For syntax, just look it up in the help, that is all I can usefully do.

That is a bit messy, but I can't see any other functions to clean it up

Da[]San · 27 May 2008 at 14:40

Cheers RIC that worked out a treat.