jag4
asked on
How do I take a character off of a number - when the "clean" or "left/right" function doesn't work?
I have a spreadsheet where the numbers for an ID were entered in with the ' in front of the IDs. I have tried the "clean" function and the "left/right" function but the number still stays the same.
Ex: '409
The cell shows up only as 409 but if I try to do a vlookup with that ID, it comes back N/A
Ex: '409
The cell shows up only as 409 but if I try to do a vlookup with that ID, it comes back N/A
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Select the column with the problem, and from the data ribbon, select text to column.
It will take you through a dialog - just take the default to everything and the column formats will be set back to general.
It will take you through a dialog - just take the default to everything and the column formats will be set back to general.
ASKER
Thanks - not sure why my brain froze and why I couldn't think of this solution but it helped tremendously!
RH