Forum Discussion
Delete text within a specific cell column
I want to delete certain text in a single column. The text looks like this: Abcd Efgh (Ijkl Mnop #1) Everything within the parentheses, including the parentheses themselves, are to be deleted...
BlackrosePress Alternatively use Text-to-columns. " (" as delimiter (i.e. a space and a left bracket). Skip the second column.