Combining many cells into one

[Karen]

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

 

[Frank Kabel]

Hi
use
=A1 & " " & B1 & " " & C1 & " " & D1 & " " & E1