Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Question (Merge two columns) 1

Status
Not open for further replies.

maharamDan

IS-IT--Management
Mar 22, 2004
31
US
Hello everyone. I am not sure if this is an easy question or not.

I have column A (First name) column B (last name)

How would I co about merging Column B in to A.

I would like frist and last name in Column A.

Thanks in advance. Daniel
 
In column C, paste in =CONCATENATE(A1, " ",B1) and drag to fill down

"'Tis an ill wind that blows no minds." - Malaclypse the Younger
 
Or just =A1&" "&B1

Regards
Ken.........

----------------------------------------------------------------------------
[peace]It's easier to beg forgiveness than ask permission[2thumbsup]

----------------------------------------------------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top