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
|