| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VB, specific cell data into email subject | Excel Discussion (Misc queries) | |||
| enter data in cell then run macro automatically | Excel Discussion (Misc queries) | |||
| Repeat Cell Data | Excel Worksheet Functions | |||
| sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
