excel - Multiple lines of text into one cell -
I am thinking how to move a line from different cells to different cells.
For example
< P> Is it possible?My
dog is brownishMy dog is brown
Thanks
You can try this command:
< = CONCATENATE (A1, A2, A3, A4)
but it will produce "My Dog Sea Brown" If you have a white space cell "My" "dog" ....
If you want to add a white spot, you can do this:
= CONCATENATE (A1, "", A2, "", A3, "", A4)
You can find more information.
Comments
Post a Comment