Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding data to existing data cell
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding data to existing data cell
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
data in cell not corresponding with entry | New Users to Excel | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) |