how to insert a word or text in front of each row in excel?
by Ramya[ Edit ] 2010-07-07 12:27:21
Insert a word in front of each row in excel:
To insert same word in front of each row in excel,
* First select the cells to which you want to append the word or text.
* Go to Format->Cells.
* Under Number tab, select "Custom option".
* Then enter the word you want to append as,
"word"@
Simultaneously you may be able to view the result in Sample text above the "Type".
* Then give "OK" to execute the result.
Now its easy to append the same word in fron of each row in excel..!!!