Just fill down and across as (no vba) needed
=MID(Sheet1!$A2,COLUMN(A1),1)
Regards Robert
"paku " wrote in message ...
Thank you Patrick but the desired output is
to be like
one character per each cell instead of 3 characters per cell
for example
W in cell (1,1)
M in cell (1,2)
Y in cell (1,3)
W in cell (2,1)
M in cell 2,2)
Y in cell (2,3)
U in cell (3,1)
H in cell (3,2)
K in cell (3,3)
and so forth
any ideas?
thanks
---
Message posted from http://www.ExcelForum.com/
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.655 / Virus Database: 420 - Release Date: 08/04/2004