Need help concatenating three columns in Excel

Need to concatenate three columns. In other words, I need it to look like this: 28-20-04_001JK_CMM in the MANUAL_ID column.
Need to combine B, C and D. Example of data attached.
Capture.PNG
maximus1974Asked:
Who is Participating?
 
AlanConnect With a Mentor ConsultantCommented:
Hi,

Enter this:

=B2 & "_" & C2 & "_" & D2

in an empty column and copy down. Then copy / paste as values from there to the ManualID column.



Alan.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Is there already any formula in column B? Because a cell can either have a value of a formula in it. If you refer the formula cell in the formula, it will create a circular reference.

It seems column B has same values as in column G, so you can use this formula in B2 and copy it down.

=G2&"_"&C2&"_"&D2

Open in new window


Or you can create another column and use this formula...
=B2&"_"&C2&"_"&D2

Open in new window

0
 
Jessica MorenoConnect With a Mentor Commented:
=$B2&"_"&$C2&"_"&$D2
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.