Remove a letter from a number?
More options:
="D"&MID(A1,2,255)&"C"
=REPLACE(A1,1,1,"D")&"C"
--
Biff
Microsoft Excel MVP
"evoxfan" wrote in message
...
I have a column of numbers beginning with a letter such as:
X05500
X95000
In the next column, I want to convert the "X" to a "D" and add a "C" to
the
end such as:
D05500C
D95000C
What is the best way to accomplish this?
Thanks in advance.
|