Remove all but the last seven digits in a cell
 

I have a Excel 2003 sheet that I download from a vendor and the column of
numbers that I need have more characters than I need. I am comparing the
column to another sheet so I need them to be uniform in length. Here is an
example: 075 - 9652582. I only need the 9652582 .
Thanks in advance

Remove all but the last seven digits in a cell
 

The usu al way:

=RIGHT(A1,7)
--
Gary''s Student - gsnu200764


"Gary Crisp" wrote:

I have a Excel 2003 sheet that I download from a vendor and the column of
numbers that I need have more characters than I need. I am comparing the
column to another sheet so I need them to be uniform in length. Here is an
example: 075 - 9652582. I only need the 9652582 .
Thanks in advance

Remove all but the last seven digits in a cell
 

Hi Gary

Try
Assuming the data is in column A, and there is nothing in columns to the
right
Mark column ADataText to ColumnsDelimitedOther type in the box next to
other space hyphen " -" (without the quotes)Finish
Column C will contain the numbers you want.
Columns A and B can be deleted if required.

Alternatively, in B1 enter
=RIGHT(A1,7) and copy down
Mark column BCopyPaste Special back over itself to "fix" the data
Delete column A
--

Regards
Roger Govier

"Gary Crisp" wrote in message
...
I have a Excel 2003 sheet that I download from a vendor and the column of
numbers that I need have more characters than I need. I am comparing the
column to another sheet so I need them to be uniform in length. Here is an
example: 075 - 9652582. I only need the 9652582 .
Thanks in advance

Remove all but the last seven digits in a cell
 

Experiment with Data | Text to Columns. You will find it easy to separate
the two parts. Just use Delimited with -
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Gary Crisp" wrote in message
...
I have a Excel 2003 sheet that I download from a vendor and the column of
numbers that I need have more characters than I need. I am comparing the
column to another sheet so I need them to be uniform in length. Here is an
example: 075 - 9652582. I only need the 9652582 .
Thanks in advance

Remove all but the last seven digits in a cell
 

Thanks to all. I had forgotten the ways to do it.

"Bernard Liengme" wrote:

Experiment with Data | Text to Columns. You will find it easy to separate
the two parts. Just use Delimited with -
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Gary Crisp" wrote in message
...
I have a Excel 2003 sheet that I download from a vendor and the column of
numbers that I need have more characters than I need. I am comparing the
column to another sheet so I need them to be uniform in length. Here is an
example: 075 - 9652582. I only need the 9652582 .
Thanks in advance

Remove all but the last seven digits in a cell
 

I was wondering if your got this to work already. One way you can try is this
insert this formula on a helper cell:

assuming the cell is A2

=left(A2,LEN(A2),-6)


"Gary Crisp" wrote:

Thanks to all. I had forgotten the ways to do it.

"Bernard Liengme" wrote:

Experiment with Data | Text to Columns. You will find it easy to separate
the two parts. Just use Delimited with -
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Gary Crisp" wrote in message
...
I have a Excel 2003 sheet that I download from a vendor and the column of
numbers that I need have more characters than I need. I am comparing the
column to another sheet so I need them to be uniform in length. Here is an
example: 075 - 9652582. I only need the 9652582 .
Thanks in advance

Remove all but the last seven digits in a cell
 

Two points...

1) You show an extra comma in your LEFT function...
you meant to post =LEFT(A2,LEN(A2)-6)

2) You didn't answer the question that was asked. The OP wants to keep the
last 6 characters, not remove them. The formula for that is =RIGHT(A2,6)

Did you post your message into the original thread? I ask because all I see
is your message... I see no other messages (not even the OP's original one;
although I do see your included copy of it) for the thread you have posted
to.

Rick


"Eddie Ortiz" wrote in message
...
I was wondering if your got this to work already. One way you can try is
this
insert this formula on a helper cell:

assuming the cell is A2

=left(A2,LEN(A2),-6)


"Gary Crisp" wrote:

Thanks to all. I had forgotten the ways to do it.

"Bernard Liengme" wrote:

Experiment with Data | Text to Columns. You will find it easy to
separate
the two parts. Just use Delimited with -
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Gary Crisp" wrote in message
...
I have a Excel 2003 sheet that I download from a vendor and the column
of
numbers that I need have more characters than I need. I am comparing
the
column to another sheet so I need them to be uniform in length. Here
is an
example: 075 - 9652582. I only need the 9652582 .
Thanks in advance

Remove all but the last seven digits in a cell
 

Did you post your message into the original thread? I ask because all I
see is your message... I see no other messages (not even the OP's original
one; although I do see your included copy of it) for the thread you have
posted to.

Rick, the reply from Eddie shows up in the thread posted originally
08/jan/2008 21:08 by Gary Crisp.
This shows up for me as part of the thread, as I had marked it (I had given
a response)
From time to time I do see totally (to me) disjointed responses just like
you appear to be seeing with this one.
I have no idea why this happens.

Thinking aloud about that a little further, I don't think I have seen that
problem since switching from OE6 to Windows Live Mail as my Newsreader.
--
Regards
Roger Govier

"Rick Rothstein (MVP - VB)" wrote in
message ...
Two points...

1) You show an extra comma in your LEFT function...
you meant to post =LEFT(A2,LEN(A2)-6)

2) You didn't answer the question that was asked. The OP wants to keep the
last 6 characters, not remove them. The formula for that is =RIGHT(A2,6)

Did you post your message into the original thread? I ask because all I
see is your message... I see no other messages (not even the OP's original
one; although I do see your included copy of it) for the thread you have
posted to.

Rick


"Eddie Ortiz" wrote in message
...
I was wondering if your got this to work already. One way you can try is
this
insert this formula on a helper cell:

assuming the cell is A2

=left(A2,LEN(A2),-6)


"Gary Crisp" wrote:

Thanks to all. I had forgotten the ways to do it.

"Bernard Liengme" wrote:

Experiment with Data | Text to Columns. You will find it easy to
separate
the two parts. Just use Delimited with -
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Gary Crisp" wrote in message
...
I have a Excel 2003 sheet that I download from a vendor and the
column of
numbers that I need have more characters than I need. I am comparing
the
column to another sheet so I need them to be uniform in length. Here
is an
example: 075 - 9652582. I only need the 9652582 .
Thanks in advance

Remove all but the last seven digits in a cell
 

Thinking aloud about that a little further, I don't think I have seen that
problem since switching from OE6 to Windows Live Mail as my Newsreader.

Is Windows **Live** Mail different than the Windows Mail that comes with
Vista, which is what I am using?

Rick

Remove all but the last seven digits in a cell
 

It is different - marginally.
I upgraded to it from the MSN site.

--
Regards
Roger Govier

"Rick Rothstein (MVP - VB)" wrote in
message ...
Thinking aloud about that a little further, I don't think I have seen
that problem since switching from OE6 to Windows Live Mail as my
Newsreader.

Is Windows **Live** Mail different than the Windows Mail that comes with
Vista, which is what I am using?

Rick

Remove all but the last seven digits in a cell
 

Okay, thanks... that "marginal" difference may then account for why I saw
only one message originally and you saw the entire thread. Although in
thinking about it, I just recently switched from Comcast's cable service to
Verizon's FIOS service, so perhaps the removal of my old accounts, and the
establishment of my new ones, may be the underlying reason for the
difference.

Rick


"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
It is different - marginally.
I upgraded to it from the MSN site.

--
Regards
Roger Govier

"Rick Rothstein (MVP - VB)" wrote in
message ...
Thinking aloud about that a little further, I don't think I have seen
that problem since switching from OE6 to Windows Live Mail as my
Newsreader.

Is Windows **Live** Mail different than the Windows Mail that comes with
Vista, which is what I am using?

Rick