J
Jeremy
Hello. I need to figure out how to parse a column of
information into several columns, while maintaining color
formats of individual characters. Here's an example of
what I need to parse:
ACTON 115.0 .00034 .00224 .000160 BONN_HORV_11A BPA
BONNVILL 2
I need to parse this into nine columns. In my
spreadsheet, the colors of some characters with respect to
other characters in any of these nine terms can be
different (ex.- in the term ".00034", the 34 is red while
the .000 is black).
When I used the text to columns wizard, it parsed the text
just as I wanted it to, but it did not keep the color
coding. Instead, it took the dominant color in the line
and assigned every parsed column entry with that color.
Any help with this problem would be greatly appreciated.
Thanks.
Jeremy
information into several columns, while maintaining color
formats of individual characters. Here's an example of
what I need to parse:
ACTON 115.0 .00034 .00224 .000160 BONN_HORV_11A BPA
BONNVILL 2
I need to parse this into nine columns. In my
spreadsheet, the colors of some characters with respect to
other characters in any of these nine terms can be
different (ex.- in the term ".00034", the 34 is red while
the .000 is black).
When I used the text to columns wizard, it parsed the text
just as I wanted it to, but it did not keep the color
coding. Instead, it took the dominant color in the line
and assigned every parsed column entry with that color.
Any help with this problem would be greatly appreciated.
Thanks.
Jeremy