The colum below is named 'REMARK'. I need a macro to extract the
cheque numbers (e.g 100138773) into different column and the names
(e.g KONNY BALL) into another column.

REMARK
========
CHQ 10013873 IFO KONNY BALL
chq10013845 ifo John Bush
chq no 10013848 pd ifo racheal
CHQ#10013928 PD IFO FRANK