 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I need to merge 3 cells containing data into 1 cell without losing any of the data. If I use the Merge button it loses everything except the first data entry. How do I do this please?
Many thanks
use the & charachter.
e.g. =A3&A4&A5
Okay except that it puts the data in a continuous line whereas I want the data to still be on seperate lines but within one cell only
Not in work to test this, but I think the function concatenate might work for this, can't see it splitting into lines within cell but will definately join them up. To keep the gaps between them enter a space in text box 2 & 4 within the function menu.
Hope this works
=A3&CHAR(10)&A4&CHAR(10)&CHAR(10)&A5
dont forget to set cell format to wrap text
=A3&CHAR(10)&A4&CHAR(10)&A5
nearly there except it puts a blank line before the first line of data
Sorted thanks