Hello, after converting text to Excel I have some strange characters in some cells. What macro would be to clear cell (make it empty) if cell has “ [ “ as part for example of [14;48H or [14;48H
Thank you very much for attention.
Hello, after converting text to Excel I have some strange characters in some cells. What macro would be to clear cell (make it empty) if cell has “ [ “ as part for example of [14;48H or [14;48H
Thank you very much for attention.
Try this macro
I have not been able to test the code with the in the find command as the will not paste or show in the excel sheet
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
Hi Mudraker Thanks a lot.
I receive error message:
Compile error
Named argument not found
SerachFormat:= is highlighted blue
After deleting “SearchFormat:=False” it works like charm. Thanks a lot Mudraker
glad to hear it works & that you solved the code problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks