Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy and paste between cells that have data
I am trying to copy and paste values to a cell that already has data in it.
For example: Cell A1 has "Mary" in it. I need to paste "-1234" next to her name so I see "Mary-1234" in cell A1. The pasted value will change for each name in column A and I have 300 cells to go through! Right now, I'm going up to the formula bar, putting my insertion point next to "Mary" and pasting the value. Is there a way faster method of doing this so I don't have to copy/paste individual cells? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy and paste between cells that have data
Try pasting the values in an adjacent column and then put a simple formula as
"=G23&"-"&H23" Where G23 is the cell which contains Mary and H23 is the adjacent cell that contains 1234 When you have it you may paste it as values before deleting the other two columns "mstack" wrote: I am trying to copy and paste values to a cell that already has data in it. For example: Cell A1 has "Mary" in it. I need to paste "-1234" next to her name so I see "Mary-1234" in cell A1. The pasted value will change for each name in column A and I have 300 cells to go through! Right now, I'm going up to the formula bar, putting my insertion point next to "Mary" and pasting the value. Is there a way faster method of doing this so I don't have to copy/paste individual cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
Creating a macros to copy and paste cells | Excel Discussion (Misc queries) | |||
How do I copy and paste cells incrementally? | Excel Worksheet Functions | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions |