Hello,
I have a text string that is dumped into an excel table daily.
looks like this:
STRING
40/36/Al/N/B11
30/48/Fe/Y/B12
20/36/Al/Y/old B12
30/36/Al/Y/B12
30/12/Fe/N/old B12
20/48/Al/Y/MISC
20/48/Fe/Y/MISC
30/12/Al/Y/MISC
30/12/Al/N/B12
20/24/Fe/Y/MISC
I want to be able to automatically organize the strings to look like this (separated into cells) while maintain text and number formats as appropriate and not converting the original string and not having to copy and paste and manually have to convert text to table (heading should be aligned with corresponding columns):
type size frame insulate Color
40 40 36 Al B11
30 30 48 Fe B12
20 20 36 Al old B12
30 30 36 Al B12
30 30 12 Fe old B12
20 20 48 Al MISC
20 20 48 Fe MISC
30 30 12 Al MISC
30 30 12 Al B12
20 20 24 Fe MISC
There can be 1000's of lines and some blanks so going through doing a manual parse is out of the question.
thanks in advance
Bookmarks