How do I use a formula to create a new line of text in a cell?

G

Guest

I'm trying to concatenate address components (Address Line 1, Address Line 2,
City, State, and Zip Code) from their individual cells into a single cell
that is formatted correctly in 2 or 3 lines of text. In my formula, I'm
trying to find a way to output Address Line 1, start a new line, put Address
Line 2 on the new line, start a new line, and put the City, State, and Zip on
the last line.
 
A

a7n9

You cannot use a function to create a new line. Worksheet functions can
only return values in the cells they are referred to, they cannot
change any thing other than that. You'd have to use VBA to achieve
that.
 
G

Gord Dibben

Jon

=A1 & CHAR(10) & B1 & CHAR(10) & C1 will give you 3 lines of text.

Format to "wrap text"


Gord Dibben MS Excel MVP


On Wed, 19 Jul 2006 08:56:03 -0700, Jon Shelton <Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting Text from single cell in column across multiple Columns 3
Seperating information in a cell 9
Concatentate text and insert blank line 2
Reference to a Variable Part of a Cell 7
How to delete a 'return' symbol in cell for data thats been import 5
how do you force a new line in a formula in Excel? 6
Merge cells with new line 7
Line break in Report expression builder 3

Top