Mix of text and numbers

[warston]

Hi, I have a cell containing the following, (cell A1) 013P3U11F.
is there any way to separate the letters from the numbers OR count how may letters are in the cell, OR to sum the numbers and tell me how many numbers are in the cell.
Thanks,
Regards,
Richard.

[PaulM100]

See these:
https://www.extendoffice.com/documen...s-in-cell.html
https://www.ablebits.com/office-addi...r-from-string/
https://www.extendoffice.com/documen...ic-string.html

[warston]

Thank you PaulM100 for pointing me in the right direction and solving my problem, I have added a reputation.
Regards,
Warston.

[Olly]

Here's a couple of User Defined Functions to do exactly what you want:

Please Login or Register  to view this content.

To return only text:

Please Login or Register  to view this content.

To return length of text only:

Please Login or Register  to view this content.

To return only numbers:

Please Login or Register  to view this content.

To return count of numeric digits:

Please Login or Register  to view this content.

To return sum of numeric digits:

Please Login or Register  to view this content.

Attachment 642623

[warston]

Thank you Olly.
Regards,
Warston.