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!

Combine number in two columns 3

Status
Not open for further replies.
Texanite

Texanite

Technical User
Aug 21, 2002
75
0
0
US
I have a 2-digit number (some with a leading zero) in Column A and a 4-digit number (some with leading zeros) in colum B. I need to combine both columns so they look like this 04-0123.

Thanks,
Texanite
 
Sort by date Sort by votes
Use the concatenate formula:

=concatenate(a1,"-",b1)

Regards,

Ian
 
Upvote 0 Downvote
or:

=A1&"-"&B1



Blue [dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
To ensure your numbers keep their format...

=TEXT(A1,"00") & "-" & TEXT(B1,"0000")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Compare two columns
Replies
2
Views
378
OCM
OCM
GPnew
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
265
combo
combo
EFFEY
  • Locked
  • Question
I have three columns in excel named 1
Replies
5
Views
118
EFFEY
EFFEY
Andrzejek
  • Locked
  • Question
Compare multiple columns in Excel 1
Replies
4
Views
468
combo
combo
Andrzejek
  • Locked
  • Question
Word - Combine files
Replies
13
Views
76
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top