populating a cell using 3 other cells

[yannb]

hello,

i have 3 cells with with the following values: frame, 0 10. I need th
fourth cell to appear as" frame 0; frame 1; frame 2; frame 3; frame 4
frame 5; frame 6; frame 7; frame 8; frame 9; frame 10"
this needs to be all in a single cell.

how would I go about doing this?

thx

yan

 

[Frank Kabel]

Hi
you may use the following user defined function:

public function combine_it(start_rng as range,end_rng as range,text_rng
as range)
dim i as imteger
dim ret_value

for i = start_rng.value to end_rng.value
if ret_value="" then
ret_value = text_rng.value & " " & i
else
ret_value="; " & text_rng.value & " " & i
end if
next i
combine_it=ret_value
end function

Now use in your worksheet in cell D1 the formula
=COMBINE_IT(B1,C1,A1)

 

[AlfD]

Hi!

Well - you could just type it in like that (or even copy it from you
post).

But I do have to ask: is this *really* what, or all, you want t
achieve? Are there future parts of your structure that might be easie
to deal with if you plan now? It just doesn't on the surface have th
power of Excel anywhere in it. Maybe you haven't told us enough fo
that to show?

Al