RE: Excel 2003 - Numbers vs text

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

If you have a lot of data like this and you are willing to live without the
dashes, then try this

1. Select all the data, both tables and press Ctrl+H, enter a hyphen in the
Find what box and nothing in the Replace with box. Click Replace All
2. Select an empty cell and press Ctrl+C
3. Select all the data and choose Edit, Paste Special, Add.

All entries with just numbers should be text and all entries that contain
alpha characters will still be text.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Craig Brandt" wrote:

This has me cofused to no end.

I have two tables each with account numbers. In one table they are shown
with a dash (123-456789), in the other, with nodash (123456789). Several of
the account numbers actually have an alpha character (X04456789 /
X04-456789). I have tried just about everything to get a good compare to no
avail.

Is there a surefire way to do a comparison? I can get the alpha-numeric
nember to match but none of the others.

Craig



.

Quantcast