View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joytickle@gmail.com is offline
external usenet poster
 
Posts: 10
Default How do I append same text to all the cells in a column at once?

Another way to append the ".xls" is just customize the format of the
data into G/General"xls".

"Abhijit Bamishte дµÀ£º
"
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.