In column A I have text like mentioned below. I am trying to separate the City Name and date in two separate columns. I don't need the other text.
Alameda 1-10-20 CSV-PAY SUMMARY RUN.csv
Palm Harbor 1-15-20 Hourly CSV-PAY SUMMARY RUN.csv
Palm Harbor 1-15-20 Salary CSV-PAY SUMMARY RUN.csv
Basically, there are various combinations like above and there are different city names. I tried using mid, search, left, right, but its not helping.
Will appreciate help.
~M
Alameda 1-10-20 CSV-PAY SUMMARY RUN.csv
Palm Harbor 1-15-20 Hourly CSV-PAY SUMMARY RUN.csv
Palm Harbor 1-15-20 Salary CSV-PAY SUMMARY RUN.csv
Basically, there are various combinations like above and there are different city names. I tried using mid, search, left, right, but its not helping.
Will appreciate help.
~M