I need a formula that delete first character and adds another

  • Thread starter Thread starter Tracey
  • Start date Start date
T

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
 
A1 =127-0112

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

If this post helps click Yes
 
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
Click to expand...

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

--ron
 
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)
 
Back
Top