Thread: I need a formula that delete first character and adds another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tracey Tracey is offline
external usenet poster
  
Posts: 78
Default I need a formula that delete first character and adds another
I need a formula that deletes and add:

Example: change

127-0112 to X27-0112

delete first character and replace with "X" or
replace first character with "X"

Tracey Harold
Reply With QuoteReply With Quote