Is there any way to extract/identify all the special characters from a cell?
I have found somethings (External Link) , but that only tells if cell has any special character, however I need to know/collect all the special characters.
I want to populate the results in a column, so that I could review those.
Looking for your great support!
Excelforum is Completely Awesome! True learning with Live Examples & Best Techniques!!
Data in Col.A
Please Login or Register to view this content.
Last edited by jindon; 08-08-2018 at 03:40 PM.
@jindon -- It's working flawlessly, however I was expecting a UDF which I could use anywhere/anytime. Can you please help me to learn that?
Use in cell like
=GetSPChar(A1)
Please Login or Register to view this content.
Many thanks in all the ways!!
What a speedy solution!
btw... I am keeping the " " as well, hence modified your code as below. Thank you!
Please Login or Register to view this content.
You are welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks