View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege Beege is offline
external usenet poster
 
Posts: 66
Default Extracting characters before or after a specific character

Brian wrote:
Howdy All,

I have data imported from a web query, but it isn't formatted the way I need
it.

I have a part number and description combined in a cell, separated by --.

How do I extract the data before the -- and then the data following the -- ?

Thanks,
Brian



How about "Text to Columns", with -- as your delimiter?

Beege