Results 1 to 4 of 4

Merge and Center

Threaded View

  1. #1
    Registered User
    Join Date
    05-25-2016
    Location
    United States, Texas
    MS-Off Ver
    MS Office 2010
    Posts
    86

    Merge and Center

    Hello, I have attached a sample file to help explain.

    I want to merge and center all the cells in column A that correspond to that states cities without having to go line by line. Is there a way to do this automatically?

    EX: I want cells A2:A4, A5:A7, A8:A9, A11:A12, and A13:A15 to merge and center.

    Maybe an if macro? I need some help lol

    The reason is because i have multiple workbooks similar to this that are 50,000+ lines and going line by line would take a week.

    Thanks in advance!!!!!!!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Merge & center with certain criteria
    By cjhale in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2015, 10:21 AM
  2. Merge and Center Gridlines
    By sammyhellsyea in forum Excel General
    Replies: 1
    Last Post: 09-19-2012, 03:34 PM
  3. Alternative To Merge & Center
    By Spencer in forum Excel General
    Replies: 2
    Last Post: 03-14-2011, 08:17 PM
  4. Merge and Center
    By lizardlounge in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2010, 01:56 AM
  5. [SOLVED] merge and center
    By GINA in forum Excel General
    Replies: 3
    Last Post: 08-15-2005, 12:05 PM
  6. Merge & Center
    By Rj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2005, 04:06 PM
  7. [SOLVED] Merge & Center
    By JT in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2005, 03:06 PM

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