+ Reply to Thread
Results 1 to 2 of 2

Text Formatting Formula (OS X & Windows User)

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2011
    Posts
    3

    Text Formatting Formula (OS X & Windows User)

    Hello Everyone,

    I have several lists of 7 digit numbers that I export from a web-based program each month. I need to take these results and combine them to a single cell and insert a comma after each result without a space. The number of results that I need to combine will vary from 5 to 500 per list. I use Office 365 on both a couple of Macs as well as a Windows Desktop

    List
    9123460
    9123461
    9123462
    9123463
    9123464
    9123465
    9123456
    9123457
    9123458
    9123459

    Needed Format
    9123460,9123461,9123462,9123463,9123464,9123465,9123456,9123457,9123458,9123459
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,580

    Re: Text Formatting Formula (OS X & Windows User)

    Put this formula in B2:

    =A2

    and this one in B3:

    =IF(A3="","",B2&","&A3)

    With cell B3 selected, double-click the fill handle, which is the small black square in the bottom right corner of the cursor - this will automatically copy the formula down to the bottom of the data that you have in column A.

    If you want the overall result in C2, then you can use this formula (format as General first):

    =LOOKUP("zzzzz",B:B)

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] formatting to Proper Case for text box enrty on user form
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2015, 06:41 PM
  2. bring the Windows user name
    By shimaa01234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2015, 01:10 PM
  3. Insert user's name into cell based on windows user login when a button is clicked.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-16-2011, 01:08 PM
  4. Pop Up Box that recognises the Windows User Logged On
    By krishatherley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2009, 09:12 AM
  5. Decimal Formatting in Windows English vs European Formatting
    By Drummer361 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2006, 09:50 AM
  6. [SOLVED] Determining User's Windows Login Name
    By Chaplain Doug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2006, 05:10 PM
  7. Formatting text in a user form text box
    By DB in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2005, 04:05 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