VBA-Extract only number from a string


No need for a macro. Paste the formula below into cell B2 and it will extract the numbers only from the cells.

=SUMPRODUCT(MID(0&A2,LARGE(INDEX(ISNUMBER(–MID(A2,ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)

By the way, if you have an entry in a cell like “swes3454gfr56” it will return 345456.

Read the entire article at the source link… malleshg24

#codango #developer #development #coder #coding

We're happy to share this resource that we found. The content displayed on this page is property of it's original author and/or their organization.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*