Splitting Numbers and Symbols from Aplhanumber/symbol String

[JamesWM]

PLEASE help.

I am trying to separate/extract the contents of an alphanumeric and symbol containing cells.

I'd like to extract Numbers (0 through 9) and Symbols/Punctuation/Non letter characters (example: &^%$#@()_+>?"|}{) in one cell and all the remaining letters in another cell.

Example: is attached

Please can someone help? I have tried various codes that people have shared but none have been able to split alphabetical letters from numbers and all other symbols/characters.

Thank you so much!

[berlan]

Quick solution and simple may be (see attached),

Please Login or Register  to view this content.

See how that works.

[pike]

or variation

Please Login or Register  to view this content.

or

Marco rip

Please Login or Register  to view this content.

[jindon]

2 in 1
=AlphaNum(A1,True/False)
True for Alhpabets
False for others

Please Login or Register  to view this content.

[berlan]

Great pike!

Still learning about character sets and RegEx, but when it comes to the the character set "[A-Z,a-z, ]", I think you can exclude exclude ",". It would not change the result in this sample data but using "[A-Za-z ]" instead would not exclude any commas and only letters for the No_Letter function.

Cheers

[pike]

Very true and modification with jindons boolean

Please Login or Register  to view this content.

[jindon]

Pike,
It needs bit of more work to meet OP's requirement

Please Login or Register  to view this content.

[pike]

or just

Please Login or Register  to view this content.

[jindon]

No, not like that easy.

ALY&ONK.A BM 100GR N E-OBYED.KONDITERY
should be
ALY ONK A BM GR N E OBYED KONDITERY
not
ALYONKA BM GR N EOBYEDKONDITERY

[pike]

arrrr ok did not see that bit

Please Login or Register  to view this content.

[JamesWM]

All of the comments are awesome and solve the question i posted - THANK YOU!

You guys are awesome for helping. Thoroughly Appreciated.