Results 1 to 8 of 8

Thread: Create formula that will merge data in multiple columns (A, B, C and D) in that order

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker watermt69's Avatar
    Join Date
    Nov 2014
    Posts
    10
    Articles
    0
    Excel Version
    2010

    Create formula that will merge data in multiple columns (A, B, C and D) in that order

    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?
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •