View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Insert apostrophe in each cell

On Tue, 4 Mar 2008 07:08:02 -0800, Shari
wrote:

For exporting, I am trying to insert an apostrophe in each cell in one of my
columns that contains numbers. There are over 800 records, how do I do this
without having to go to each cell and do it manually?


Where do you want to insert the apostrophe? Beginning, end, middle, third
character from the right ????
--ron