ExcelBanter - getting data from another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - getting data from another cell (https://www.excelbanter.com/excel-discussion-misc-queries/14069-getting-data-another-cell.html)

Jackinluv

getting data from another cell

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

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
(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
.

All times are GMT +1. The time now is 08:36 PM.