Combining many cells into one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that has addresses broken out into multiple cells. For
example:

| 123 | Main | St. | NW | #104 |

Is there any way to take the info in those 5 individual cells and combine
them into one cell in Excel 97? For example:

| 123 Main St. NW #104 |

Thanks in advance!

Karen
 
You must log in or register to reply here.

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 2
Parsing line breaks into separate cells 3
Merge contents of two columns into one? 3
database - looking for dups 3
How to split columns with multiple lines w/in cells 2
formula for database search - is it possible? 7
Insert Cells every other row 1
Access Access 2007 Delete Part of Text 0

Back
Top