you can also copy pastespecial append values

My version of Excel (2002) doesn't have a paste special append option. That
would be very useful!

Biff

"Martin Fishlock" wrote in message
...
If you don't want the VBA route you can also copy pastespecial append
values

or in another column =a1&".xls" and then copy and paste special values.

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Abhijit Bamishte" wrote:

There are 100 rows in my excel sheet. I want to appent same word (".xls")
to
all the cell data in a perticular column at once instance. Is there any
formula/function for this? Otherwise I have to edit the data in every
cell in
that column for all 100 rows and append the word.