Results 1 to 10 of 12

Thread: Split Upper / Lower case + concatenate rows

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    13
    The arrays are only 2 cells wide. You select the two cells, adjust the formula, then ctrl+shift+Enter to enter the formula into both cells. Then you can copy the pair of cells down.

  2. #2
    Junior Member
    Join Date
    Sep 2014
    Posts
    6
    Rep Power
    0
    thanks p45cal

    @snb, my appologies, I thought it didn't make a difference.
    apperently seen the other solution, it doesn't.

Similar Threads

  1. Excel Macro to Split Multiple Columns into rows
    By cali-novice in forum Excel Help
    Replies: 2
    Last Post: 05-16-2014, 12:34 PM
  2. Replies: 6
    Last Post: 04-13-2014, 02:31 AM
  3. Random Time Between Fixed Lower And Upper Limits
    By papabill in forum Excel Help
    Replies: 9
    Last Post: 07-22-2013, 05:01 PM
  4. Replies: 4
    Last Post: 05-01-2013, 09:49 PM
  5. Reverse name in excel with upper case,edit formula
    By shrinivasmj in forum Excel Help
    Replies: 3
    Last Post: 09-11-2012, 01:31 PM

Tags for this Thread

Posting Permissions

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