Remove a letter from a number?
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. |
Remove a letter from a number?
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. |
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. |
All times are GMT +1. The time now is 12:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com