Need to combine multiple cells into on cell
='Sheet1'!A1&" / "&'Sheet2'!A1&" / "&'Sheet3'!A1&" / "&'Sheet4'!A1
You can use the & symbol to join cells/text strings. Note that text is
entered using quotation marks. This formula, for example, returns the values
of A1 from Sheets 1 - 4 with the forward slash seperating each value.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"papercut" wrote:
I need to combine multiple cells on one worksheet into one cell on another
worksheet. I also need the info to be seperated like this:
info / info / info / info.
Is there a way to do this and can it be explained in laymans terms???
Thanks
|