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