Results 1 to 10 of 13

Thread: No. separation

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-27-2014, 05:44 PM #3
    mahmoud-lee
    mahmoud-lee is offline
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

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