Since 3/5/2010 8:45:01 AM, gjlinker has written 0 articles and participated in 1 conversations. gjlinker signature:
gjlinker's replies:
Items(1) /1
Delimit using a formula 24362 (3/4/2010 9:54:01 PM) microsoft.public.excel.misc I am using the functions
=MID(A1,FIND("(",A1)+1,FIND("/",A1)-FIND("(",A1)-1) and
=MID(A1,FIND("/",A1)+1,FIND(")",A1)-FIND("/",A1)-1)
to get a couple of numbers out of a cell which use the delimiters (,... Utf
gjlinker is following:
Items(1) /1
Delimit using a formula 24362 (3/4/2010 9:54:01 PM) microsoft.public.excel.misc I am using the functions
=MID(A1,FIND("(",A1)+1,FIND("/",A1)-FIND("(",A1)-1) and
=MID(A1,FIND("/",A1)+1,FIND(")",A1)-FIND("/",A1)-1)
to get a couple of numbers out of a cell which use the delimiters (,... Utf