EXCEL 2000 - CLEARING LETTERS LEAVING NUMBERS 1

[cousinconley]

I have an large spreadsheet. In that spreadsheet is column A. There are many rows in column A. Each row to column A contains a account number and description. Is there a way to clear out the description, which is letters only, and leave the account number?

Example:
A
1 12345 description
2 43456 description
3 64567 description

 

[DaleWatson123321]

If your numbers are consistently 5 digits, then a simple solution would be:

Enter =LEFT(A1,6) in cell B1, and copy it down for all the rows. Then use Edit - Paste Special - and choose "Values" to convert the formulas to values. Then copy the contents of "B" column over to "A".

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[DaleWatson123321]

Further suggestion...

If your numbers are NOT consistent, then you are better off using the following formula:

=LEFT(A1,FIND(" ",A1))

This formula will search for the "space" character, and pull out the numbers to the left of the space.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca