how to insert a word or text in front of each row in excel?

by Ramya 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..!!! Razz
Razz

Tagged in:

1251
like
1
dislike
0
mail
flag

You must LOGIN to add comments