| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Taking data from 3 columns to make the fourth.
I have three columns of data: first name, middle name, last name. I want to
make a fourth column that contains the first letter of the first and middle name and the entire last name to make a fourth column. example: john edward smith in the first column and the fourth column would be jesmith. thanks in advance. -- Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
| spliting a column of data into multiple columns | Excel Discussion (Misc queries) | |||
| Colors of columns after sorting data in the supporting table | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) | |||
Threaded Mode
