Results 1 to 5 of 5

Merge and Centre

Threaded View

  1. 11-19-2018, 04:39 AM #1
    SimonCampbell
    SimonCampbell is offline
    Registered User
    Join Date
    10-09-2017
    Location
    Stavanger, Norway
    MS-Off Ver
    O365
    Posts
    78

    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.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. How do I get "centre across selection" to centre properly?
    By Marjon in forum Excel General
    Replies: 5
    Last Post: 03-16-2006, 08:24 PM
  7. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1