• Status: Solved
  • Priority: High
  • Security: Private
  • Views: 21
  • Last Modified:

Need help combining columns in Excel

Need to combine three columns MANUAL_ID, MFG_CODE, TYPE separated by an underscore. I attached a screenshot  of the raw data.

Ex of what it needs to look like:
28-20-04_001JK_CMM
Capture.PNG
0
maximus1974
Asked:
maximus1974
1 Solution
 
peter mostmansIT Developer & AnalistCommented:
you can concatenate with & 

see attachment
Answer.xlsx
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.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now