Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing a letter to the beginning of each part number of a column
Hi
I had read the question by Brian Denny and found that I just had the opp. problem of his. I need to remove the letter at the beginning of each part number. Pls advise. tnks. vcff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing a letter to the beginning of each part number of a co
"vcff" wrote:
I need to remove the letter at the beginning of each part number. =right(A1,len(A1)-1) That results in text. If you want a number, then: =value(right(...)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing a letter to the beginning of each part number of a co
If you have a single letter then take the substring beginning at the 2nd
character of the part No. (say in cell A1) =MID(A1,2,256) Regards, Stefi vcff ezt *rta: Hi I had read the question by Brian Denny and found that I just had the opp. problem of his. I need to remove the letter at the beginning of each part number. Pls advise. tnks. vcff |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing a letter to the beginning of each part number of a co
tnks for the help but i don't get the formula for the valve cos after input
=valve(right(A1,len(A1)-1)) I got #NAME? is there anything that I miss out? " wrote: "vcff" wrote: I need to remove the letter at the beginning of each part number. =right(A1,len(A1)-1) That results in text. If you want a number, then: =value(right(...)) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing a letter to the beginning of each part number of a co
sorry I make a mistake on the wording "value" and had got it right.
However if my cell Ai is P0012 (double zero), it will only show as 12. How can I keep the zero's? tnks and b r " wrote: "vcff" wrote: I need to remove the letter at the beginning of each part number. =right(A1,len(A1)-1) That results in text. If you want a number, then: =value(right(...)) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing a letter to the beginning of each part number of a co
Either leave it as text, or format the cell as 0000
-- David Biddulph "vcff" wrote in message ... sorry I make a mistake on the wording "value" and had got it right. However if my cell Ai is P0012 (double zero), it will only show as 12. How can I keep the zero's? tnks and b r " wrote: "vcff" wrote: I need to remove the letter at the beginning of each part number. =right(A1,len(A1)-1) That results in text. If you want a number, then: =value(right(...)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a column from the last letter or 2 letters of a part numbe | Excel Discussion (Misc queries) | |||
Non updatable Unique Random Number | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) |