Results 1 to 2 of 2

Text Formatting Formula (OS X & Windows User)

Threaded View

reznap Text Formatting Formula (OS X... 09-02-2016, 06:20 AM
Pete_UK Re: Text Formatting Formula... 09-02-2016, 06:44 AM
  1. 09-02-2016, 06:20 AM #1
    reznap is offline
    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
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. [SOLVED] 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. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1