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