INSERT THE SAME WORD IN FRONT OF EACH ROW

A

Annie23

I have a spreadsheet with 2,608 rows, I need to enter the works "programmable
controller" in front the words already in each row. How could I do this
without having to enter in each row?
 
F

Francois via OfficeKB.com

Annie23 said:
I have a spreadsheet with 2,608 rows, I need to enter the works "programmable
controller" in front the words already in each row. How could I do this
without having to enter in each row?
Click to expand...


Make sure you have a blank col to left of the sheet

Then, for example, enter "programmable controller "&A2 into cell A1.
Then copy down as far as you want.

You'll get the idea after you've played with it a bit
 
R

Roger Govier

Hi Annie

If you are saying you have text in column A1:A2608, and you would like
to have the words "programmable controller" in front of each word (or
sentence) then, in an empty column enter (maybe column B)
="Programmable controller "&A1
Copy down the column to row 2608 by double clicking on the fill handle
(the small black cross you see when you hover over the bottom right of a
cell).
Then, copy this new block of data and place your cursor in cell A1 and
Paste Special>Values

You can then delete column B
 
G

Gary''s Student

Select the cells and then pull-down:

Format > Cells... > Number > Custom and replace general with "programmable
controller" @
 
F

Francois via OfficeKB.com

Gary''s Student said:
Select the cells and then pull-down:

Format > Cells... > Number > Custom and replace general with "programmable
controller" @
Click to expand...

One point about this method, the contents of the cell is not changed, ie
you can't extract the "programme controller" part.

it will however print to hard copy
 
Top