View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Francois via OfficeKB.com
 
Posts: n/a
Default INSERT THE SAME WORD IN FRONT OF EACH ROW

Annie23 wrote:
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?



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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200602/1