Results 1 to 10 of 13

Thread: No. separation

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    Unfortunately, this is not required
    This version of Genius (Mr. Rick Rothstein)
    =SUBSTITUTE(MID(TRIM($A$3);COLUMNS($B10:B10);1);" ";" ")
    But I want this formula divides the numbers from right to left
    Last edited by mahmoud-lee; 02-27-2014 at 06:17 PM.

  2. #2
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    12
    Quote Originally Posted by mahmoud-lee View Post
    Unfortunately, this is not required
    ??!!
    Quote Originally Posted by mahmoud-lee View Post
    But I want this formula divides the numbers from right to left
    Yes, they give you exactly the same results as on your example workbook (except for Ingolf's observation in msg#4). See attached.
    Attached Files Attached Files
    Last edited by p45cal; 02-27-2014 at 06:37 PM.

Similar Threads

  1. Excel Number Format: Indian Style Comma Separation
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 6
    Last Post: 09-18-2013, 11:38 AM
  2. Follow-up to "Excel Number Format: Indian Style Comma Separation"
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 2
    Last Post: 04-14-2012, 10:46 PM

Posting Permissions

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