Text Functions,
Hello, Can someone help me solve this problem. I have a mailing list
consisting of single cell names (first <could be initials, Middle, Last, and
a sufix <Sr. Jr. IV, etc.). What I have been trying to do is to separate
the names into two columns,
A (Separate to) B
c
A1 A Francisco Madrigal A Francisco Madrigal
A2 A J Benning A J Benning
A3 Aaron Isaac Laine Aaron Isaac Laine
A4 Abraham A. Abreu Sr Abraham A. Abreu Sr
I have tried making several formulas but so far I have not been able to get
the separated into the two columms.
--
Lowell Shoaf
Realtor
RE/MAX Gulfstream Realty
Sarasota, Florida
|