| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional: stop function under certain condition
Hi, i have a question about stopping a function at certain specified point.
i'm trying to simplify the list with data entered as follows: "xxxxx xx xxxxxx" i just need the first part, so i want to trim the part after the long space. length of the first part ranges, with or without space in between. is there a way to use function like =LEFT and stop when it reaches 2 space? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I add More than three condition in conditional formating | Excel Discussion (Misc queries) | |||
| Can I add More than three condition in conditional formating | Excel Discussion (Misc queries) | |||
| 4 condition conditional formatting | Excel Worksheet Functions | |||
| conditional formatting - multiple condition | Excel Discussion (Misc queries) | |||
| how many condition for conditional sum wizard ? | Excel Worksheet Functions | |||
Threaded Mode
