Hi Barret,

I dont have the english name for the function but you can find it in
text.

In Dutch it is Vind.Spec(value,text_ref,starting_value)

What it does is: you search for the ',' and it will give its position,
all you have to do now is: say the tekst is is A1,
B1=vind.spec(",",A1) if the cell A1 is empty you'll get an
errromessage, so maybe a test if it's empty should be included:

The Dutch Syntax:
=ALS(A1<"",RECHTS(A1,(LENGTE(A1)-VIND.SPEC(",",A1)-1)),"")

Possible English Syntax:
= IF(A1<"";RIGTH(A1,(LEN(A12)-FIND.SPEC(",";A1)-1));"")

The -1 after FIND.SPEC depends if you have spaces after the comma, one
space is -1, two spaces is -2, etc etc.
No spaces then forget the -1

Good luck
:)


--
hhalle

Male
------------------------------------------------------------------------
hhalle's Profile: http://www.excelforum.com/member.php...o&userid=20829
View this thread: http://www.excelforum.com/showthread...hreadid=573581