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.
Who is Participating?
AlanConnect With a Mentor ConsultantCommented:

Enter this:

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

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

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.


Open in new window

Or you can create another column and use this formula...

Open in new window

Jessica MorenoConnect With a Mentor Commented:
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.