Excel merges (Full Version)

All Forums >> [Web Development] >> Computer Software and Hardware issues



Message

sentinel -> Excel merges (11/14/2005 12:15:15)

hey all...

I have an excel spreadsheet that has a first name, last name, username and phone colum.

Our email system uses a format like this

first name . lastname @ company.com

how can i take the firstname column, move it to another cell, add a period, add thelast name column then put a @company.com after all of it?

I have about 20,000 records to do and am looking for an easy way.

Thanks



jaybee -> RE: Excel merges (11/14/2005 12:50:45)

Look in the help section for info on recording macros.

Basically you turn recording on, do it once, stop it.
Then run the macro and it does it for all the others.



danrendrag -> RE: Excel merges (11/14/2005 12:58:48)

The easiest way would be to use the Concatenate() function in an adjacent cell.

You can find examples of its use in the help files.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.03125