split/filter a column with numbers and text

I have a column where both numbers and text exist. I'd like to split them into two streams, one with numbers only, and the other with text or text plus numbers.

Say column A has below values

100

Amazon

Book21

200

Help/Date

...

I want to filter out the text values and keep the numbers only.

Developer

Parse

Preparation

Text Mining

Accepted answers

Qiu

@JokeFun

Trust the force, trust the RegEx. 😁

New Workflow3.yxmd

atcodedog05

Hi @JokeFun

If your unconformable with warning messages. We can extend on @Qiu's solution to accommodate negative numbers.

Hope this helps 🙂

numbers only regex.yxmd

All comments

Qiu

@JokeFun
RegMatch maybe is the tool we need

New Workflow3.yxmd

JokeFun

@Qiu Thanks, I just tried, it works for numbers with no decimals, but also excludes numbers like 123.12. How can we do that o include all numbers?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335