HI
I have a file to import, which contains a number of columns, one of which is a text field containing a varying number of words and field length. Is there a way via Text to columns functionality or via VBA where i can look for the end of the text and put the break in there?
Example below : The items in the quotations are the area i need to split out (sadly no quotations in the source file!) The text field will always end in a letter.
C001 19083 "First Word1 Secondword2 thirdword forthword4A" F 555.000 332.000 223.000 CSE
If it helps.. The next field after the text will always be an F , X or an S
Hope this makes sense. Appreciate any advise on this
Cheers
I have a file to import, which contains a number of columns, one of which is a text field containing a varying number of words and field length. Is there a way via Text to columns functionality or via VBA where i can look for the end of the text and put the break in there?
Example below : The items in the quotations are the area i need to split out (sadly no quotations in the source file!) The text field will always end in a letter.
C001 19083 "First Word1 Secondword2 thirdword forthword4A" F 555.000 332.000 223.000 CSE
If it helps.. The next field after the text will always be an F , X or an S
Hope this makes sense. Appreciate any advise on this
Cheers