Don't use merged cells. It causes a lot of pain.
I'm out of guesses/ideas here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote in message
...
Thank you for your reply
I would like to return both chars in combined cell A1 & A2
If this is true, then return A in cell A1 and M in cell A2, but A1 and A2
are combined cell, which show as below
A
M
Do you have any suggestion?
Thank you very much for any suggestion
Eric