Shifting text on column B to column A automatically

I want to move some text from column B, C and D to the end of the text in Column A.

For example:

From
Column A Column B Column C Column D
158 Happy Rd Happy Valley Happy City USA

To
Column A Column B Column C Column D
158 Happy Rd Happy Valley Happy City USA

All text will be moved to the column A.

Is there any shortcut to do that? I have about 100 rows to perform this.

Thanks.

One way to do it:

Insert a column to the left of column A and enter the following in what is now cell A1:

=(B1 & " " &C1 & " " & D1 & " " & E1)

Then copy the formula down in each cell for the range of your data.

Hope this helps,
theDude

Thanks for the help. It works.