Hello,
Looking for help to do the following:
Column A has 50,000 rows with repetitive names (78 total) followed by a number.
I want to use Column H which contains a list of the prefixes in Column A and delete.
Flash Fill will not work because of some weird things in the data.
Text to columns will not work becasue - is present in some of the names in Column A.
Any ideas?
Thank you!
Looking for help to do the following:
Column A has 50,000 rows with repetitive names (78 total) followed by a number.
I want to use Column H which contains a list of the prefixes in Column A and delete.
Flash Fill will not work because of some weird things in the data.
Text to columns will not work becasue - is present in some of the names in Column A.
Any ideas?
Thank you!