Hi,
Please go through the attachment. i want to extract numbers from text by using vba (need sub procedure not function).
thank you.
Regards
shiva
Hi,
Please go through the attachment. i want to extract numbers from text by using vba (need sub procedure not function).
thank you.
Regards
shiva
The most natural would be probably solution using regular expressions
You can find a lot of examples on this forum (and in the net).
So would be lovely if you do this lesson yourself (already knowing what to search).
Notice that your decimal part is on input side sometimes denoted as dot, sometimes as comma (on input side dot could also be thousands separator). And on output side - always as comma.
Best Regards,
Kaper
This does require a Function (from OZGRID). Hope you can use it.
Please Login or Register to view this content.
Please Login or Register to view this content.
Bit tricky
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks