leading zeros

  • Thread starter Thread starter nancy
  • Start date Start date
N

nancy

I have a 10 character field (numbers). I would like to strip off the
left most character, ending up with a 9 character field. I'm not at
all familiar with Excel so any help with what must be a basic question
is most appreciated.

Thank you:)
 
I have a 10 character field (numbers). I would like to strip off the
left most character, ending up with a 9 character field. I'm not at
all familiar with Excel so any help with what must be a basic question
is most appreciated.

Thank you:)
Click to expand...

This should do what you are after.

A1 is the cell referance
9 is the number of characters you want to extract

=RIGHT(A1,9)

Andy
 
this formua should work

= RIGHT(A1,9)

(change A1 to the cell value of the field you are wanting
to strip down)

Hope this works
Lee
 
I have a 10 character field (numbers). I would like to strip off the
left most character, ending up with a 9 character field. I'm not at
all familiar with Excel so any help with what must be a basic question
is most appreciated.

Thank you:)
Click to expand...
Try:
=RIGHT(A1,9)


--ron
 
An alternative would be to copy the field to an empty column, do data>text
to columns,
select fixed width, click next, click between the left most character and
the rest, click next,
select the leftmost field and check do not import (skip), select the filed
you are keeping and
select text from column data format (to keep any leading zeros)
 
Back
Top