Thread: Replace last three characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ToddEZ ToddEZ is offline
external usenet poster
  
Posts: 60
Default Replace last three characters
try the replace function. Use use the formula helper box for the context.

=Replace()

"Phillips via OfficeKB.com" wrote:

Hiya! i was wondering if there was a way to replace just the last three
characters in a cell? example i have 123456000 i would like to have instead
of the 000 a 959 so it would be 123456959? any ideas?

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


Reply With QuoteReply With Quote