Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jerry Arnone, PMP
 
Posts: n/a
Default 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   Report Post  
Jerry Arnone, PMP
 
Posts: n/a
Default

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   Report Post  
Biff
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text to Columns / Importing Data John Thomson Excel Discussion (Misc queries) 0 May 4th 05 08:21 PM
spliting a column of data into multiple columns CiceroCF Excel Discussion (Misc queries) 7 March 25th 05 01:40 AM
Colors of columns after sorting data in the supporting table Booger_Boy Charts and Charting in Excel 6 January 24th 05 03:41 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
Drop-down selection fills data across multiple columns Tom Excel Discussion (Misc queries) 7 December 2nd 04 01:43 AM


All times are GMT +1. The time now is 04:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"