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

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

F G
a
b a b
c a b c
d a b c d
e a b c d e

Is this what you want?
Sub accumulate()
mystr = Cells(4, "f")
For i = 5 To Cells(Rows.Count, "f").End(xlUp).Row
mystr = mystr & " " & Cells(i, "f")
Cells(i, "g") = mystr
Next i
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/english/

....then try this formula

=MCONCAT(IF(F5<"",$F$5:F5,""))

copy down as far as needed


"mike3004" wrote:

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

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

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

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

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

Teethless mama

I try your addin fucntion , this is exactly done from my case.
Thank you!

Mike HK


"Teethless mama" wrote:

Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/english/

...then try this formula

=MCONCAT(IF(F5<"",$F$5:F5,""))

copy down as far as needed


"mike3004" wrote:

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

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