Thread: remove characters on both sides
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
enrico via OfficeKB.com enrico via OfficeKB.com is offline
external usenet poster
  
Posts: 9
Default remove characters on both sides
what if i want to insert a period on the second to the last part of a field
but the number of characters varies?
e.g. 1375 = 137.5
625 = 62.5
500 = 50.0

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1

Reply With QuoteReply With Quote