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
Chat Forum
[closed]
Quick Excel question
-
Posted 2 years ago #
-
use the & charachter.
e.g. =A3&A4&A5
Posted 2 years ago # -
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
Posted 2 years ago # -
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 worksPosted 2 years ago # -
=A3&CHAR(10)&A4&CHAR(10)&CHAR(10)&A5
dont forget to set cell format to wrap text
Posted 2 years ago # -
=A3&CHAR(10)&A4&CHAR(10)&A5
nearly there except it puts a blank line before the first line of data
Posted 2 years ago # -
Sorted thanks
Posted 2 years ago #
Topic Closed
This topic has been closed to new replies.
