Remove a letter from a number?

TheMSsForum.com: The Microsoft Software Forum

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.
Top

RE: Remove a letter from a number? by to_sheeloo

to_sheeloo
Wed Oct 08 17:38:31 CDT 2008

If you have your nos in Col A starting at A1
then in B1 enter
="D"&RIGHT(A1,LEN(A1)-1)&"C"
and copy down...

"evoxfan" wrote:

> 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.
Top

Re: Remove a letter from a number? by T

T
Wed Oct 08 21:10:27 CDT 2008

More options:

="D"&MID(A1,2,255)&"C"

=REPLACE(A1,1,1,"D")&"C"


--
Biff
Microsoft Excel MVP


"evoxfan" <evoxfan@discussions.microsoft.com> wrote in message
news:4C6F0FB8-1805-4603-AC94-CC169DEE4DEF@microsoft.com...
>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.


Top