I have a spreadsheet wherein I need to extract partial data from every cell in one column and move it to a separate column.
Ex:
Existing column B: Switch Housing CoverUSE 0164290
I need it to be in two columns:
Column B: Switch Housing Cover
Column C: USE 0164290
I have had a programmer working on this and he cannot seem to get it right.
Any help appreciated.
Ciao,
Stacy
Ex:
Existing column B: Switch Housing CoverUSE 0164290
I need it to be in two columns:
Column B: Switch Housing Cover
Column C: USE 0164290
I have had a programmer working on this and he cannot seem to get it right.
Any help appreciated.
Ciao,
Stacy