General discussion

Locked

Excel String Wrapping

By stuart.douglas ·
Currenly I'm taking several string entries from different cells in Excel and joing them into one cell. Question is how do you get the new string to go onto a new line in different positions in the new cell.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel String Wrapping

by DKlippert In reply to Excel String Wrapping

If you are using a formula to concatenate the strings, you can use CHAR(10) for a new line.
=A1&CHAR(10)&B1
The cell must be formatted as Wrap text so you won't see a little square (□).
If your using VBA, you can use VBLF or CHR(10).

Collapse -

Excel String Wrapping

by stuart.douglas In reply to Excel String Wrapping

This is a good answer and works well, except when the cell you are joining together contains something like ?20 Baker Street? then it separates out the 20, Baker and Street and puts them on new lines.

Collapse -

Excel String Wrapping

by DKlippert In reply to Excel String Wrapping

=A1&CHAR(10)&B1 does work. CHAR(10) is the code for a new line.

When you say '20 Baker Street'. Do you mean that string in one cell or three seperate cells?
If the lines do not appear as you want, increase the width of the column.

Collapse -

Excel String Wrapping

by stuart.douglas In reply to Excel String Wrapping

Good answer, thanks for the help

Collapse -

Excel String Wrapping

by stuart.douglas In reply to Excel String Wrapping

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums