Did you look at my macro solution? I, for one, am STILL not sure what you
want. Send a workbook to my address below if desired along with a complete
explanation of what you DO want and an example.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mike3004" wrote in message
...
Thanks all warm reply!
Let me explain my requires, I want to access text from F4 to F100 indeed:
such as
F4 I
F5 feel
F6 so
F7 happy
...
anyone have idea?

"Rick Rothstein (MVP - VB)" wrote:

I just have to see if I can trade my fingers in for a new set... they
never
seem to type I am thinking anymore.<g

Thanks for catching that David.

Rick


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
I think Rick intended to say =G5&F7 instead of =G1&F7
--
David Biddulph

"Rick Rothstein (MVP - VB)" wrote
in
message ...
If I understand your question correctly, consider this. Let's say your
first formula (=F5&F6) is in G5, then put this in G6 and copy down...

=G1&F7

Rick


"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