View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terri Terri is offline
external usenet poster
 
Posts: 110
Default 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?