if your data is in A1 put this function in B1

=MID(A1,FIND(" ",A1,FIND("&",A1)+2)+1,100)

Motaad Wrote:
I have another trade list where the names are listed Bill & Mary
Williams. I
know I can use the data function, text to columns to separate Bill &
Mary
using the delimited function using other (&). Is there any way of
separating
between Mary and Williams into separate cells?????
--
Motaad


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=572652