+ Reply to Thread
Results 1 to 5 of 5

Merge and Centre

  1. #1
    Registered User
    Join Date
    10-09-2017
    Location
    Stavanger, Norway
    MS-Off Ver
    O365
    Posts
    57

    Merge and Centre

    Does anyone know of a way to apply Merge and Center to a very long Array. I have a column for year and a column for Month (1...12). I would like to Merge and Center the years. I have over 19000 rows with multiple occurrences of any given year.

    Or even better I would like to convert the two columns to a single date format
    Year 1999
    Month 5
    Result 01.05.99
    Last edited by SimonCampbell; 11-19-2018 at 04:43 AM.

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Merge and Centre

    Hi

    Try
    =DATE(1999,5,1) or
    if year in A2 and month in B2
    =DATE(A2,B2,1)

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,879

    Re: Merge and Centre

    Assuming your years are in column A (starting with A2), and months in column B, put this formula in C2:

    =DATE(A2;B2;1)

    Format the cell in the style you wish to see, then copy down. You can fix the values of those formulae in column C, and then you could delete columns A and B if no longer needed.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    10-09-2017
    Location
    Stavanger, Norway
    MS-Off Ver
    O365
    Posts
    57

    Re: Merge and Centre

    Pete
    Thanks, that'll do just fine... I could have probably Googled my way to a solution.

    Simon

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,879

    Re: Merge and Centre

    Glad to help, Simon.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark this thread as SOLVED.

    Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Centre Across Selection problem
    By Keibri in forum Excel General
    Replies: 7
    Last Post: 12-27-2016, 05:56 PM
  2. VBA Centre Across Selection Help!
    By Happy Booking in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-19-2014, 10:44 AM
  3. hyperlinking to the centre of the screen
    By Alex06 in forum Excel General
    Replies: 11
    Last Post: 04-11-2010, 06:22 AM
  4. cost centre linking
    By mingali in forum Excel General
    Replies: 0
    Last Post: 07-24-2009, 11:27 AM
  5. [SOLVED] undue merge and centre
    By ED in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-31-2006, 03:50 PM
  6. Replies: 5
    Last Post: 03-16-2006, 08:24 PM
  7. [SOLVED] What is the Keyboard Shortcut of Merge and Centre Tool Command
    By Rao Ratan Singh in forum Excel General
    Replies: 4
    Last Post: 02-14-2005, 12:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1