| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trim cells
=LEFT(A1,FIND("-",A1)-1)
Have a look at RIGHT and MID for future problems like this best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "Cassius" wrote in message ... 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? |
| Reply |
| 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 | |||
Linear Mode
