ok going to reexplain here.

As stated we have the above information that needs sorting.
What we have right now is this. We are able to take the string and put
individual pieces of data within that string into individual columns.
But right now our code just takes a string, looks at the first bit of
data and sticks it into column A, 2nd bit of data into column B, 3rd
bit into column C....... you get the idea.

Now the problem is the order in which the data is in the string is not
exactly the same each time. We would appreciate it if someone would
explain how we can sort through the date so things like the contacts
email doesn't end up in fax column, it goes into the email column (as
an example).

As stated the columns that we need filling a
A Company Name -Always present and 1st
B- Account# -Always present and 2nd
C- CCR -NOT always present, text field
D- Notes -NOT always present, text field
E- Address -Always present, 99.99% of the time starts
with a number
F- Unit# -NOT always present, when present it
starts with the letter
“U”
G- City -Always present
H- Postal/Zip Code -Always present, this can be US or CA formats
I- Phone -Always present, field starts with
“T:”
J- Fax -Always present, field starts with
“F:”
K- Email -NOT always present, field starts with
“E:” and has”@”
L- LIC# -NOT always present, field starts with
”LIC#:”
M- Work Type -NOT always present, field starts with
”Work Type:”

and example date is above.
I'll get the code we have so far later, can't atm.
Thanks!


On Sep 8, 9:12*am, Paul Robinson wrote:
Hi
What is the question?
regards
Paul

On Sep 8, 6:21*am, flashback wrote:

I have followed a previous thread on this topichttp://groups.google.com/group/microsoft.public.excel.programming/bro...,
which covers the same issue that I have, except for the type of data
string.
My data looks like this after I do the TextTOColumns function. I have
added a row with headings to better help understand the final layout.
The first entry contains all the required items to match the columns
and the others show the same problem as in the previous tread. This
issue is beyond my knowledge of VBA. Any feedback/help *would be
welcome.
Many thanks in advance!!

Company Name, Account#,CCR, * * Notes,Address, Unit#,City,Postal/ZipCode,
Phone,Fax, * * *Email,LIC#, WorkType

1. * * *ABC INC, 0000015583, MCR1461, ABC ELE, 1365 MyStreet, U 34, MyCity,
L5T 2J5, T: (123)456-7890, F: 123456-7890, E: , LIC #:
0007002665, Work Type:
2. * * *ABC INC, 0000015583, 1365 MyStreet, U 34, MyCity, L5T 2J5, T:
(123)456-7890, F: 123456-7890, E: , LIC #: 0007002665,
Work Type:
3. * * *ABC INC, 0000015583, 1365 MyStreet, , MyCity, L5T 2J5, T:
(123)456-7890, F: 123456-7890, E: , LIC #: 0007002665,
Work Type:
4. * * *ABC INC, 0000015583, 1365 MyStreet, MyCity, L5T 2J5, T:
(123)456-7890, F: 123456-7890, E: ,
5. * * *ABC INC, 0000015583, MCR1461, 1365 MyStreet, MyCity, L5T 2J5, T:
(123)456-7890, F: 123456-7890, LIC #: 0007002665, Work Type: