getting data from multiple columns into 1 column

[doraima29]

Hi,

I'm trying to create a worksheet that is filled data on the first 3 columns such as -- first name, last name and ID number. Then I want to combine them into one column as:

first 2 letters of first name and last name then the ID number. Is there a macro or easy way to do it? Any more resources or website that should help me learn these functions.

I am currently using MS Excel 2000

[oldchippy]

Hi,

I'm trying to create a worksheet that is filled data on the first 3 columns such as -- first name, last name and ID number. Then I want to combine them into one column as:

first 2 letters of first name and last name then the ID number. Is there a macro or easy way to do it? Any more resources or website that should help me learn these functions.

I am currently using MS Excel 2000

Hi doraima29,

Try this,

=UPPER(LEFT(A2,2))&UPPER(LEFT(B2,2))&C2 , then copy down

oldchippy

[doraima29]

Awesome! thank you.