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!

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

Column Formula 1

Status
Not open for further replies.
CCPKGUY

CCPKGUY

IS-IT--Management
Feb 25, 2013
30
US
I have two columns

Last Name First, Middle
Harris Vincent D.

How to merge the two columns into one column. I need a formula to have the whole name under one column.
 
Sort by date Sort by votes
=A1 & B1

and if you need a space:

=A1 & " " & B1

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
Use "&" in formula to join texts, if necessary add space " " (=A2&" "&B2). If you need only final text, copy column and paste as values, next delete cource columns.

combo
 
Upvote 0 Downvote
Thanks bluedragon2 that worked perfectly.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
324
SkipVought
S
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
189
TomSalvato
TomSalvato
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
175
Andrzejek
Andrzejek
titanif
  • Locked
  • Question
Office 365- Spill A Table Column Into Another Tables Column
Replies
1
Views
143
SkipVought
S
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
233
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top