View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mitch
 
Posts: n/a
Default 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