I can't answer your question, but I wonder why you said =F5&""&F6 rather
than just =F5&F6 (and similarly in your other expressions)?
If you had said =F5&" "&F6 (with a space between the quotes) then I could
have understood it, but without the space the &""& seems equivalent to &
--
David Biddulph

"mike3004" wrote in message
...
When I copy one column to next column, the function should be auto changed
to:
=F5&""&F6
=F6&""&F7
=F7&""&F8
...

But I want to change like these:
=F4&""&F5
=F4&""&F5&""&F6
=F4&""&F5&""&F6&""&F7
=F4&""&F5&""&F6&""&F7&""&F8
...
How should we set ? Or could not ?

Thanks a lot!

Mike HK