Cell will number and text

[outlawspeeder]

I looking for a VBA way to pull and replace cells that have both text and numbers. I nee to do math with the numbers and put it back in to the cell. Not all the Cells have Text. The ones without text, there is no need for math.

123 xyz ----->123*2--------->246
234----------------------------->234
2-------------------------------->2
24xyz---------->24*2---------->28
8809 abc----->8809*2------->17618

Thanks

 

[outlawspeeder]

so you have Power Query build-in

this (and 2013) require Power Query add-in
the rest doesn't support PQ



why? you can use .xlsm extension

Add ins are blocked. When I go to the "COM Add-in" under options the selections are grayed out. Policy from those that do not understand that these are helpful tools.

 

[sandy666]

2019, 365, 2016

so you have Power Query build-in

Power Query aka Get&Transform

 

[Rick Rothstein]

Rick
If Cell.Value Like "*[!0-9]*" Then

"*[!0-9]*" What is this?

The rest I follow

Like is an operator and compares what is on its left with a pattern string on its right. You can look the Like Operator up in the help files to see all of the possibilities, but to answer your direct question everything inside and including the square brackets represents a single character in the pattern string... this particular character is any not digit character. So, the expressions is testing the text in the cell being examined to see if it contains any non-digit characters.