Hi
I am attaching a file. There is a list of numbers that are text and I need to convert them to digital. The numbers are 75 55555 and five spaces at the end of the number on the right. When I delete the five "spaces" at the end and remove the space between the number on the left and the number on the right, the resulting number moves to the right of the cell. It's tedious to do each number in that fashion. I have over ten thousand numbers.
Appreciate your help.
Patish
Patish
In B1, put the formula and drag it down
This remove the space and then you can value to convert them in to value. See attached.
Please Login or Register to view this content.
Last edited by AB33; 11-16-2014 at 09:13 AM.
you'll also need to put VALUE() around that ie
to truly turn it into a numberPlease Login or Register to view this content.
find/replace
find space
replace with nothing worked for me
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I thank you gentlemen for your time and knowledge!! (Y)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks