Formula to extract numbers from cell?

1. Formula to extract numbers from cell?

Hi all!

Hope you are doing well!

Could someone help me with the following problem:

1.I have a cell with let say a specific numbers that are not constant (e.g. 1,23,36,57 or 21,5,7) and they are separated with let say comma.
2.I need a formula that will extract all the numbers each of them in different cell regardless how digits the number has.

2. Re: Formula to extract numbers from cell?

Assuming that your data start in A1:

=IFERROR(--TRIM(MID(SUBSTITUTE(","&\$A1,",",REPT(" ",125)),125*COLUMNS(\$A:A),125)),"")

copied across and down, as needed.

3. Re: Formula to extract numbers from cell?

Or maybe this
Enter in B1 and copy across
Formula:
`Please Login or Register  to view this content.`

 v A B C D E F G H 1 1,23,36,57 or 21,5,7 1 23 36 57 21 5 7

4. Re: Formula to extract numbers from cell?

I don't think that "or" appears in the cells - I think it's there separating two examples of what might.

5. Re: Formula to extract numbers from cell?

A lot of tnx for both of you!

6. Re: Formula to extract numbers from cell?

You're welcome.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1