Dear Sir,

I am using Seagate Infordesktop Software which generate report in MS Excel
2002 format.

My report is designed in such a way that a reference number located the to
right hand coner of each block od data.

I need to edit the data so that it appear at the first column of each line.

Original Report Format
Ref No 1
xxxxx xxxxx xxxx
xxxxx xxxxx xxxx
xxxxx xxxxx xxxx
xxxxx xxxxx xxxx

Ref No 2
xxxxx xxxxx xxxx
xxxxx xxxxx xxxx
xxxxx xxxxx xxxx
xxxxx xxxxx xxxx


Edited Report Format (what I need)
Ref No 1 xxxxx xxxxx xxxxx
Ref No 1 xxxxx xxxxx xxxxx
Ref No 1 xxxxx xxxxx xxxxx
Ref No 1 xxxxx xxxxx xxxxx

Ref No 2 xxxxx xxxxx xxxxx
Ref No 2 xxxxx xxxxx xxxxx
Ref No 2 xxxxx xxxxx xxxxx
Ref No 2 xxxxx xxxxx xxxxx

Is there any short cut or key board command to do this instead of copy the
reference number for each block and past each blank cell one by one?

I would be glad if someone who is knowledgable in Ms Excel 2002 could assist
me.

Thanks

Low Seng Kuang
Malaysia

--
A36B58K641