watermt69
New member
- Joined
- Nov 19, 2014
- Messages
- 11
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
I need to create a formula that will merge data in multiple columns (A, B, C and D) in that order. It should also yield an Equipment ID# that looks exactly like the text in the highlighted cell of the attached spreadsheet. I'm being asked to ensure the leading zeros (0) show in the Equipment ID# automatically. Then I'm to copy the formula down from E2 to E83 (this I believe I can handle.
Can anyone assist me on this task?
Can anyone assist me on this task?