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 |
#2
|
|||
|
|||
I meant to say.....
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 three column and the fourth column would be jesmith. -- Jerry "Jerry Arnone, PMP" wrote: 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 |
#3
|
|||
|
|||
Hi!
Try this: =LEFT(A1,1)&LEFT(B1,1)&C1 Biff "Jerry Arnone, PMP" wrote in message ... I meant to say..... 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 three column and the fourth column would be jesmith. -- Jerry "Jerry Arnone, PMP" wrote: 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 |
#4
|
|||
|
|||
Jerry
=LEFT(A1,1)&LEFT(B1,1)&C1 entered in D1 and copied down column D. Gord Dibben Excel MVP On Mon, 23 May 2005 19:24:01 -0700, "Jerry Arnone, PMP" wrote: I meant to say..... 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 three column and the fourth column would be jesmith. |
Reply |
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) |