+ Reply to Thread
Results 1 to 12 of 12

Convert array to numbers delete commas (Easy one )

  1. #1
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Convert array to numbers delete commas (Easy one )

    Just need some help I have values in column CDE2-CDE130 thats in this format 2,9,8 and 4,5,7 and 2,0 ...I would like it to converted to 298 and 457 and 20 It must only delete the commas out......Easy one rep given for your help..Thank you
    Last edited by ricklou; 02-06-2017 at 05:31 AM.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Convert array to numbers delete commas (Easy one )

    try this.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Convert array to numbers delete commas (Easy one )

    Try this

    =SUBSTITUTE(CDE2,",","")
    and copy down
    Teach me Excel VBA

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: Convert array to numbers delete commas (Easy one )

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Re: Convert array to numbers delete commas (Easy one )

    Uploading sheet.......very weird ran macros and its not giving an error and its not doing anything.Thank you Bakerman Imran Jindon
    Attached Files Attached Files
    Last edited by ricklou; 02-06-2017 at 06:31 AM.

  6. #6
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Re: Convert array to numbers delete commas (Easy one )

    Attached the sheet .........
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Re: Convert array to numbers delete commas (Easy one )

    Quote Originally Posted by ImranBhatti View Post
    Try this



    and copy down
    Need a macro thanks.....link to a button

  8. #8
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Convert array to numbers delete commas (Easy one )

    Select the cells
    CRTL+H
    Find what box, type (,) comma
    Replace with box, type nothing
    Click replace all.
    Then
    repeat the process (With out closing the menu)

    Find what box, type space
    Replace with box, type nothing
    Click replace all.
    Last edited by AB33; 02-06-2017 at 07:00 AM.

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: Convert array to numbers delete commas (Easy one )

    Ah,, I din't see this thread was updated... forum problem...
    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Re: Convert array to numbers delete commas (Easy one )

    Quote Originally Posted by jindon View Post
    Ah,, I din't see this thread was updated... forum problem...
    Please Login or Register  to view this content.
    Jindon thanks your code works 100% Thank you!!!!!

  11. #11
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: Convert array to numbers delete commas (Easy one )

    You are welcome and thanks for the rep.
    Convert array to numbers delete commas (Easy one )
    It was an easy one indeed.

  12. #12
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Convert array to numbers delete commas (Easy one )

    You're welcome and thanks for rep+.

+ 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. Convert numbers - switch commas for decimals and vice versa
    By shdwfx in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-14-2016, 03:43 PM
  2. How to convert a range of numbers to sequence of numbers in an array
    By MetisConnect in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-25-2015, 11:53 AM
  3. [SOLVED] How to convert list to one cell with commas?
    By jp001 in forum Excel General
    Replies: 2
    Last Post: 03-13-2015, 08:29 AM
  4. Convert text to numbers and delete blank rows
    By bonsaitrees in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2015, 04:44 PM
  5. Replies: 5
    Last Post: 01-17-2014, 05:56 PM
  6. [SOLVED] 2 separate columns with numbers separated by commas and single numbers not, need sum
    By Slothbob in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2013, 04:33 PM
  7. Replies: 2
    Last Post: 05-26-2010, 03:56 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