I have a spreadsheet that has a column of partial email addresses, what I
need to do is add this (ilstu.edu) to the end of the existing data there
without having to retype all the information.

I'm in a real hurry here..can someone help?

Teri

You need a helper column and at the top of that column type

=CONCATENATE(A1,$C$1)

where A1 is your partial email taext and C1 is the bit at the end you want
to add. You then drag down.

Once done you can copy and paste the new column back to its original place


"Curious" wrote:

I have a spreadsheet that has a column of partial email addresses, what I
need to do is add this (ilstu.edu) to the end of the existing data there
without having to retype all the information.

I'm in a real hurry here..can someone help?

Teri

B1 =A1&"ilstu.edu"

copy from B1 all the way down as far as needed


"Curious" wrote:

I have a spreadsheet that has a column of partial email addresses, what I
need to do is add this (ilstu.edu) to the end of the existing data there
without having to retype all the information.

I'm in a real hurry here..can someone help?

Teri