How do I add data to multiple Excel cells that have existing data.

P

Paula

I need to add repetitive data to approximately 1500 cells that already have
existing data. I need the existing data, which is not repetitive, to stay.
Can this be done with out pasting into each cell separately?
 
M

Myrna Larson

Assuming you're talking about something like adding some text to the cells,
you could use a "helper" column with a formula, i.e.

="Some text "&A1

Copy this down as far as needed. Then you can Edit/Copy the column with the
formulas, then select the cells in column A and Edit/Paste Special and select
the Values option.
 
G

Gord Dibben

Paula

What type of data are you speaking of?

Text, numeric, mixed?

Please post back, but you will most likely need a helper column or a VBA
macro.

To add text to a cell you can, in a cell adjacent to it enter a formula.

Assume in A1 you have Paula and want to change to Paula'a shoes.

In B1 enter =A1 & " " & "shoe's"

Drag copy down column B.

Gord Dibben Excel MVP
 
Top