Help counting order numbers

[skate1991]

HI

I have a list of order numbers for example 07715,07716,07719 all in the same cell, I was just wondering if there was a formula to add how many order numbers are in the cell,

The order numbers can either be split by , or /

Thanks

[dilipandey]

Hi skate,

The order numbers can either be split by , or /

Yes... you can get the data Text To Columns and then you can simply count them using Count function. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[skate1991]

Thanks for your help

[dilipandey]

you are welcome skate...

If this is solved, Please mark the thread as [solved]. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[estige]

Hi, one way to get the number directly:

Please Login or Register  to view this content.