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

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(...))

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

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(...))

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(...))

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(...))