Hi there, I have 2 columns of data containing numbers and words. How do I delete one column from the other? The data in not of fixed length or position in the cell and can be anything numerical value, word or value / combo.
For example:
Column A Column B
Delete:
Test from: 1987 Test orange 23.0
46 from: Blue game 46 one hundred
Sample from: Sample 33212 onboard
f27 from: already there f27 forever
Many thanks
Bookmarks