Help ! Ive copied a price list of a PDF file and need to put it back
into original columns in an Excel file.
I tried Text to columns but as the descriptions vary in length it didnt
work & to do manually would take a while cause there is about 800 to
do.
The columns need to be set out like this -
Number. Code. Description. EACH. Price.
First few below


1 BB-1a Open/check/seal 300/900/1800 type CCU (includes up to 60 tags)
EACH $32.90
2 BB-1b Open/check/seal 240/480/CMUX Line RIM Housing (seals and
designations only) EACH $21.55
3 BB-1c Replace Captive nut (steel); Lock (pillar); Cover Top
plate;Sealing plug or Centre stud EACH $17.04
4 BB-1e Replace CCU Cap EACH $106.41


--
ferg
------------------------------------------------------------------------
ferg's Profile: http://www.excelforum.com/member.php...o&userid=36519
View this thread: http://www.excelforum.com/showthread...hreadid=569408