Need help with Excel...

[Joshua Gordon]

So I am a beginner with Excel. I can make spreadsheets that do math, but nothin fancy. I recently purchased a list from my county, and I need help merging cells. Each little piece of info is in it's own cell. Like the address 123 abc st city state is in 5 separate cells. How can I set it up so that 123 abc st is in one cell?

[Thomas Thatcher]

Hello Joshua,

You can use the CONCATENATE formula.

Type in: =CONCATENATE(A1," ",B1," ",C1," ",D1," ",E1)

step 1: type in formula in the formula bar

step 2: press enter to get your results

step 3: drag to copy down

Hope this helps.

Thomas Thatcher