getting data from another cell

J

Jackinluv

Hi
I'm having a column A2 of full name eg (HOWES,CARRIE,L) I want to copy
the first name, last name and the inital to three another cells like A3 LAST
NAME = HOWES, A4 FIRST NAME = CARRIE, A5 MI = L

Please help me to do it .

Thanks
jack
 
J

Jason Morin

Go to Data > Text to columns and use comma as your
delimiter.

HTH
Jason
Atlanta, GA
-----Original Message-----
Hi
I'm having a column A2 of full name eg
Click to expand...
(HOWES,CARRIE,L) I want to copy
 
Top