Hi Otto

Thanks for your reply Otto.

The Lotus combine facility allows you to grab whole chunks of other
spreadsheets and combine them with the one you are working on. This is a
particularly useful feature as it not only brings back 'actual' values, but
also performs calculations
and brings in formulae.

We have tried a number of functions including CONCATENATE (which is very
useful for combining two or more columns (say of text) into one (eg useful
application is combining first name/last name columns into one).

This is a particularly complex area of functionality which LOTUS performed
really well, but which we can't replicate easily in Excel. We know we can use
MACROs but they aren't as elegant, and take a lot more looking after than the
LOTUS feature.

Kind regards

Rob

"Otto Moehrbach" wrote:

What does the Lotus "Combine" facility do? Perhaps it is like "Concatenate"
in Excel. HTH Otto
"seawardr" wrote in message
...
in LOTUS 123 i use the 'combine' facility which works very well - how can
i
replicate this in excel

thanks

rob