Hello all,
Like the title here suggests, what formula will extract characters A-Z , a-z and 0-9 from a cell.
Hence omit . spaces, dots, semicolon, question-mark, exclamation marks etc.
for instance.
From
A8^Kite?
abc 450
4xsection-
action?
54
12/31/2017
To
A8Kite
abc450
4xsection
action
54
12312017
Will appreciate any help.
Thanks.
Like the title here suggests, what formula will extract characters A-Z , a-z and 0-9 from a cell.
Hence omit . spaces, dots, semicolon, question-mark, exclamation marks etc.
for instance.
From
A8^Kite?
abc 450
4xsection-
action?
54
12/31/2017
To
A8Kite
abc450
4xsection
action
54
12312017
Will appreciate any help.
Thanks.
Last edited: