| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INSERT THE SAME WORD IN FRONT OF EACH ROW
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INSERT THE SAME WORD IN FRONT OF EACH ROW
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 SpecialValues You can then delete column B -- Regards Roger Govier "Annie23" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INSERT THE SAME WORD IN FRONT OF EACH ROW
Select the cells and then pull-down:
Format Cells... Number Custom and replace general with "programmable controller" @ -- Gary's Student "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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INSERT THE SAME WORD IN FRONT OF EACH ROW
Gary''s Student wrote:
Select the cells and then pull-down: Format Cells... Number Custom and replace general with "programmable controller" @ 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? 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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200602/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging documents,exporting long landscape table to word with page breaks & numbers | Excel Discussion (Misc queries) | |||
| How do I insert an excel spreadsheet in Word? | Excel Discussion (Misc queries) | |||
| Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
| Excel should have the same Insert Symbol feature as Word. | Excel Discussion (Misc queries) | |||
| Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
Linear Mode
