| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting cells using formula; RIGHT/LEFT not applicable
Hi,
I use a web query and need a formula which would enable me to automatically split cells into 2 and 3 cells. The data looks like this "24-10" or "24-20-2" or "9-8-1" i.e. it's apperance is inconsistent as to the lenght of the numbers but always separated by "-". Text to columns is the obvious solution here but this is a web query and a lot of sheets involved so something automated would be preferred. Any help is appreciated Regards Mitch |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Threaded Mode
