Excel 2007 : Add same text to multiple cells

**wereldvlaggen.nl** · 02-11-2009, 02:55 PM

Hi,

I have a list of all my products ( I sell flags) in Excel and need to add eg this text: 150cm x 90cm to a lot of cells, see example below

cells not visible)

Grenada 150cm x 90cm
Marshall-Islands
Maurutania
Palau
Rhodesia
Salomon Islands
Trinidad und Tobago

is it possible to do this like quick time or do I have to cut and paste >800 times?? Please tell me its possible..

**NBVC** · 02-11-2009, 02:57 PM

If you click on the cell that currently contains the text you want to copy... then click and hold the little black box in the bottom right corner of that cell....then drag down as far as you want...that will copy it down

**wereldvlaggen.nl** · 02-11-2009, 03:08 PM

Originally Posted by NBVC

If you click on the cell that currently contains the text you want to copy... then click and hold the little black box in the bottom right corner of that cell....then drag down as far as you want...that will copy it down

Hi, thats not what i meant. If I do that i get the following:

Grenada 150cm x 90cm
Grenada 150cm x 90cm
Grenada 150cm x 90cm
Grenada 150cm x 90cm
Grenada 150cm x 90cm
Grenada 150cm x 90cm

But i want this:

Grenada 150cm x 90cm
Marshall-Islands 150cm x 90cm
Maurutania 150cm x 90cm
Palau 150cm x 90cm
Rhodesia 150cm x 90cm

**NBVC** · 02-11-2009, 03:19 PM

I see, I thought those were 2 separate columns...

Say your first entry is in A1... then in a B2, enter formula:

Please Login or Register  to view this content.

and copy it down..

then you can copy and paste special|Values over the original and delete the formula column...

edit as necessary if using the formula elsewhere.

**wereldvlaggen.nl** · 02-11-2009, 03:29 PM

Tried but this Excel greenhorn cant get it right, sorry.

I have put the text i need to copy ( 150cm x 90cm ) in A1
The first cell it has to come in is: C3
The text Algeria is already there in C3.
so it will have to be Algeria 150cm x 90cm
C4 is Burkino Faso
C5 is KA- Québec etc

Originally Posted by NBVC

I see, I thought those were 2 separate columns...

Say your first entry is in A1... then in a B2, enter formula:

=A2&"

Please Login or Register  to view this content.

and copy it down..

then you can copy and paste special|Values over the original and delete the formula column...

edit as necessary if using the formula elsewhere.

**Richard Schollar** · 02-11-2009, 03:40 PM

Then in D3 (or some other adjacent cell) use the formula:

=C3 & " " & $A$1

and copy the formula down then do the Copy>PasteSpecial>Values

Richard

**NBVC** · 02-11-2009, 03:44 PM

So if you do it that way, then in D3, enter:

=C3&" "&$A$1 copied down.

Then copy that new range and go to C3.. go to Edit|Paste Special and select Values..

Then clikc OK

You can now delete the D3:D whatever range...

**wereldvlaggen.nl** · 02-11-2009, 04:52 PM

Originally Posted by NBVC

So if you do it that way, then in D3, enter:

=C3&" "&$A$1 copied down.

Then copy that new range and go to C3.. go to Edit|Paste Special and select Values..

Then clikc OK

You can now delete the D3:D whatever range...

Thanks, it worked.....

**NBVC** · 02-11-2009, 04:55 PM

Great!

Can you please mark your thread solved?

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save