LinkBack URL
About LinkBacks
Hi,
My cells contain data in this syntax: 0002, 0040, 0402 etc. (road numbers)
I need a macro that returns only 2, 40, 402, respectively. Basically the e digits to the right of the last zero.
Help with the code is needed.
Hi,
My cells contain data in this syntax: 0002, 0040, 0402 etc. (road numbers)
I need a macro that returns only 2, 40, 402, respectively. Basically the e digits to the right of the last zero.
Help with the code is needed.
Please * if you like the answer
In B2
Paste this formula and drag it down
=VALUE(A2)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
CheersVery practical function..
Thank you for the feedback
Nice, AlKey.Originally Posted by AlKey
I did the longer way of making a function saving defined as long:
Please Login or Register to view this content.
No need of Macro/Function
Select Col.A - [Data] - [Text to columns] - [OK]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks