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 Chris Miller 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

Andrzejek
  • Question
Formula with & and a single quote 2
Replies
4
Views
504
OzFoxy
OzFoxy
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
387
SkipVought
S
PSchubert
  • Question
Excel: Formula only works with certain numerical values
Replies
12
Views
540
dhookom
dhookom
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
237
TomSalvato
TomSalvato
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
200
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top