Re: Merging cells

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If A1 had "Fred" and A2 has "Holland", then =A2 & ", " & A1 will give
"Holland, Fred"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"kolds" <kolds@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6C22AB19-C1E8-470F-BEB7-6CCB47BBD905@xxxxxxxxxxxxxxxx
We have many excel spreadsheets that we use to track employees. My
company
just recently transfered the info from Word to Excel. I am new to the
company and fairly new to Excel. We have decided to merge the name cells
from two to one (one cell-first name, one cell-last name). We want to do
this to help in our searches for people. I have no idea how to do this.
I
am sure there has to be an easier way than retyping everyone name into one
cell. Any advice would be appreciated!


.

Quantcast