platesigns

Hi

Can someone help with step 5 and 6 below ?

Thanks





STEP 1: COPY SELECTION FROM EXCEL
STEP2 : RUN PASTE SPECIAL MACRO
STEP 3: RUN THE CONVERT TEXT MACRO
STEP4: RUN THE FONT CHANGE MACRO
WITH LINE SPACING
STEP5: ON LINE ONE, CAN WE USE A MACRO
TO PLACE THE CURSOR AT THE SECOND LETTER
PRECEDING THE FIRST NUMBER AND HENCE CREATE
A NEW LINE
STEP6: FOR EVERY LINE THAT FOLLOWS AFTER STEP 5,
AFTER THE FIRST 3 LETTERS, THE MUST BE 3 POINT SPACE
UNLESS ITS AN i IN WHICH CASE IT MUST BE 4 SPACES

*****after paste special in corel draw******

CANE WEIGHBRIDGEK1-01-03-100
-ELEELECTRICAL CONTROLS AND CABLES
-INSINSTRUMENTATION
-SU1STRUCTURE

*******this is the final result i want to end up with **********

CANE WEIGHBRIDGE
K1-01-03-100
-ELE ELECTRICAL CONTROLS AND CABLES
-INS INSTRUMENTATION
-SU1 STRUCTURE

****codes for some of the steps above******************