I saved a scan of a label sheet as an excel file. Each piece of info is being
allocated its own cell. Right now it is in the format:
<name1<name2<name3
<street1<street2<street3
<state+1<state+2<state3+
<name4<name5<name6
<street4<street5<street6
<state+4<state+5<state+6
<name7<name8<name9
<street7<street8<street9
<state+7<state+8<state+9
..
..
..
....and continues in this manner for a few hundred pages.
I want to be able to manipulate the info so it's in the format:
<name1<street address1<city,state,zip1
<name2<street address2<city,state,zip2
<name3<street address3<city,state,zip3
..
..
..
....how can i do this? I am a relative excel noobie and don't even know where
to start. The fact that the info isnt a simple text or ascii file with
delimiters doesnt help the matter. Any and all help is appreciated