macro to convert text string
 

Assume Williamson, Josh is in A1

in B1
=Left(A1,Find(" ",A1)-1)

in C1
= right(A1,Len(A1)-(len(B1)+2))

--
Regards,
Tom Ogilvy


"Josh" wrote in message
om...
My macro skills are a bit rusty, so I need some help on this one. An
example of the problem at hand: I would like to be able to convert a
text string in one cell([williamson, josh] or [josh williamson]) to
two different cells (williamson in cell 1 and josh in cell 2.

Thanks for the help