Thread: edit a record like 17.00 gbp so it becomes 17.00 using a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John
 
Posts: n/a
Default edit a record like 17.00 gbp so it becomes 17.00 using a formula
I have cut and paste a lot of data from a web site, but it all has 'gbp'
after each amount i.e. 17.00 gbp. I need to get rid of the gbp so I can do a
SUM calculation. I hope someone can help.
Reply With QuoteReply With Quote