Results 1 to 4 of 4

Excel 2007 : Insert comma to text string

Threaded View

  1. #1
    Registered User
    Join Date
    08-08-2008
    Location
    Johannesburg
    MS-Off Ver
    2007
    Posts
    55

    Insert comma to text string

    Hi Guys

    I want to insert comma at the end of every word/text string in a cell
    A
    1 WordX
    2 Word Bx
    3 WordZz
    Will be like this:
    A
    1 WordX,
    2 Word Bx,
    3 WordZz,
    I'm using the =CONCATENATE(A1,",")
    to solve that problem,
    Yet, is there a better way to do that?

    I also need the macro to do the action on all the cells in column A
    till it find an empty cell, then its stops.

    Many thanks in advance.
    Last edited by oldchippy; 10-23-2008 at 04:24 PM.
    Using Excel 2007.
    Amit Cohen

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to display help text in the Insert function wizard (Excel)
    By sudhakard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2009, 11:01 AM
  2. insert text if criteria met
    By freshstart in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2008, 10:37 AM
  3. removing part text string with a formula
    By pertenax in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2007, 07:08 AM
  4. How to make a formula from a text string?
    By Helsinghof in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2007, 09:07 AM
  5. Convert cell reference to text string
    By packe in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-08-2007, 09:56 AM

Tags for this Thread

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