Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim cells
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRIM | Excel Discussion (Misc queries) | |||
=TRIM | Excel Discussion (Misc queries) | |||
Trim cells to a character | Excel Worksheet Functions | |||
Trim Cells | Excel Discussion (Misc queries) | |||
Trim help please | New Users to Excel |