Sort/Filter issue
We have a problem. We have a long string of data that had sections separated
by spaces. We want to pull out the first section and the third section.
Problem is there not all the same length. Example below
B360N V ORB 505 123
FB350N V FLA 505
So we want to pull out the B360N and the FB350N and the ORB & FLA into two
columns.
Does anyone have any suggestions --
We can do in access or excel?
|