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
|