macro or function to count the number of 'number' characters in a cell

**aarona** · 07-30-2019, 05:05 AM

Hi All,

Need your help again, i'm looking for a macro/function to count the number of "numbers listed" in a cell (regardless what is their delimiter: ex: space, comma, semi-colon, ~, -)

Attached is a sample output (manual)

Thanks!

**AliGW** · 07-30-2019, 05:07 AM

That's not the number of characters - it's the number of words (numbers listed). Is that what you meant?

Try this in B2:

=LEN(A2)-LEN(SUBSTITUTE(A2," ",""))+1

**aarona** · 07-30-2019, 05:12 AM

Thanks AligW, yes you are correct, however the formula will only work if the delimiter is *space*, looking for a solution that will work whatever delimiter is used. But still thanks, for the suggestion I can still use this.

**AliGW** · 07-30-2019, 05:14 AM

Well, we can't help unless you tell us what other delimiters you are using. Post more meaningful sample data and you might get a better solution.

**aarona** · 07-30-2019, 05:15 AM

Thanks AligW, updated the original post.

**jindon** · 07-30-2019, 05:16 AM

UDF

Use in cell like
=CountNumbers(A2)

Please Login or Register  to view this content.

**AliGW** · 07-30-2019, 05:17 AM

Not good enough. We need a COMPLETE list of delimiters used. Don't post-edit your posts, please - it makes the thread hard to follow.

**aarona** · 07-30-2019, 05:19 AM

Originally Posted by jindon

UDF

Use in cell like
=CountNumbers(A2)
...

Thanks Jindon! working

**jindon** · 07-30-2019, 05:28 AM

You are welcome and thanks for the rep.

macro or function to count the number of 'number' characters in a cell

LinkBack

Thread Tools

Rate This Thread

Display

macro or function to count the number of 'number' characters in a cell

Re: macro or function to count the number of 'number' characters in a cell

Re: macro or function to count the number of 'number' characters in a cell

Re: macro or function to count the number of 'number' characters in a cell

Re: macro or function to count the number of 'number' characters in a cell

Re: macro or function to count the number of 'number' characters in a cell

Re: macro or function to count the number of 'number' characters in a cell

Re: macro or function to count the number of 'number' characters in a cell

Re: macro or function to count the number of 'number' characters in a cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to count the number of characters in a cell

[SOLVED] Vba code to count the number of characters from a cell and to do an action

checking number of characters in a cell macro

[SOLVED] how to count number of characters in a cell

Count the number of Characters in a cell?

Count Number of Characters in a cell?

How do you count number of characters in a single cell

Bookmarks

Bookmarks

Posting Permissions