| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I truncate something like this?
I have a column with text like
BRAND X - version 1 BRAND X - version 2.4 BRAND Y - version 3D BRAND Y - version 8C BRAND Y - version 3.5.6 BRAND Z - version 5X and so on. It's very long spreadsheet. I'd like to chop off the version info (which is of varying length) and group everything together by just the brand name. How do I do this? Thanks for any input. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to truncate or separate the first 3 characters/digits of co | Excel Discussion (Misc queries) | |||
| truncate | Excel Worksheet Functions | |||
| truncate ssn to first four digits | Excel Discussion (Misc queries) | |||
| I WANT to truncate my leading zeros | Excel Discussion (Misc queries) | |||
| Truncate scientific notation | Excel Worksheet Functions | |||
Threaded Mode
