Hi. I have a column of text cells that contain upper case words (one or more) followed by proper case words (one or more).
I'd like to delete the proper case words. As an example:
ABBAYE DES ROCS Blanche des Honnelles 1060
I would like this to read just:
ABBAYE DES ROCS
I know nothing about programming or even know if this is possible.
Thanks in advance
Bookmarks