C
Cassius
I have thousands of cells with text that I want to eliminate certain text or
atleast parse out. A sample of the data is below.
CPS-PL-WARSAW-PIPETEST SERVICE 4911
EDI-US-TX-VICTORIA-GEMOCO CEMENTING#4075
EDI-ZA-WUK-MOSSEL BAY #1228
CPS-SG-SINGAPORE-HWS #2727
4M RENTALS & REPAIR INC-LAFAYETTE
A&A LOCKSMITH-LAFAYETTE
I would like to just keep everything to the left of the dash. For example
my final product would look like this:
CPS
EDI
CPS
4M RENTALS & REPAIR INC
A&A LOCKSMITH
Any suggestions?
atleast parse out. A sample of the data is below.
CPS-PL-WARSAW-PIPETEST SERVICE 4911
EDI-US-TX-VICTORIA-GEMOCO CEMENTING#4075
EDI-ZA-WUK-MOSSEL BAY #1228
CPS-SG-SINGAPORE-HWS #2727
4M RENTALS & REPAIR INC-LAFAYETTE
A&A LOCKSMITH-LAFAYETTE
I would like to just keep everything to the left of the dash. For example
my final product would look like this:
CPS
EDI
CPS
4M RENTALS & REPAIR INC
A&A LOCKSMITH
Any suggestions?