Thread: I need a formula that delete first character and adds another
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default I need a formula that delete first character and adds another
On Tue, 11 Aug 2009 10:34:01 -0700, Tracey
wrote:

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

=REPLACE(A1,1,1,"X")

--ron
Reply With QuoteReply With Quote