Combining Many Cells Into One

G

Guest

I have a worksheet which breaks out addresses into different cells. For
example,

| 123 | Main | St. | NW | #102 |

Instead, I would like to combine those 5 bits of info into one cell. For
example,

| 123 Main St. NW #102 |

Is there any way to do that with Excel 97?

Thanks in advance!

Karen
 
M

Myrna Larson

=B2&" "&C2&" "&D2&" ", etc.


On Mon, 11 Oct 2004 13:45:01 -0700, "Karen Arias" <Karen
 

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

Combining many cells into one 1
Parsing line breaks into separate cells 3
Merge contents of two columns into one? 3
Access Access 2007 Delete Part of Text 0
Insert a cell value into a link to another worksheet. 10
Combining Letters and Numbers 1
Combining cells with separater 6
Combining cells conditionally 3

Top