Ranger_Rocks
Well-Known Member
To keep the leading zeroes, first format all cells to TEXT, then paste.An alternative is to open in a text editor and do a search and replace:
Search for: LABEL="Replace with: carriage returnThat will put in PID in a new row starting with the PID ID.
ie,
7A7-01-01"><CODE>0076</CODE><CODE>81DC</CODE><CODE>1497</CODE></DATA><DATA 

7A7-01-02"><CODE>5A11</CODE><CODE>E7F0</CODE><CODE>8275</CODE></DATA><DATA
From there just search for "><CODE and replace with a couple spaces, and continue on with </CODE><CODE and </CODE></DATA><DATA
That gets you here:
7A7-01-01 >0076 >81DC >1497 

7A7-01-02 >5A11 >E7F0 >8275
(Note: [& Warning: Anal minutia] I left the leading > so when I pasted it into Numbers the program didn't remove the leading 0's before I could assign each cell as text).
Sponsored