I need a formula that delete first character and adds another

[Tracey]

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

 

[Jacob Skaria]

A1 =127-0112

Try the formula in B1
="X" & MID(A1,2,LEN(A1))

If this post helps click Yes

 

[Ron Rosenfeld]

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

 

[Rick Rothstein]

You said you "need a formula", so I presume the responses Ron and Jacob gave
you answer you question. However, you did post your question in a
programming newsgroup, so on the off chance you were really looking for a VB
solution...

Range("A1").Value = "X" & Mid(Range("A1").Value, 2)