View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default adding data to existing data cell

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