Results 1 to 8 of 8

Urgent help - Replace comma by dot

This is a discussion on Urgent help - Replace comma by dot within the Excel Questions forums, part of the Question Forums category; Application values AAAA 4,2 BBBB 0,5 CCCC 3,5 In the above values column the values are like 4,2 and 0,5 ...

  1. #1
    New Member
    Join Date
    Jan 2009
    Posts
    38

    Post Urgent help - Replace comma by dot

    Applicationvalues
    AAAA 4,2
    BBBB0,5
    CCCC3,5


    In the above values column the values are like 4,2 and 0,5 ...
    I want it to be replaced by dot like 4.2 and 0.5 .. in another column as shown below.

    Applicationsvalues
    AAAA4.2
    BBBB0.5
    CCCC3.5

  2. #2
    Board Regular
    Join Date
    Oct 2006
    Location
    日本
    Posts
    2,457

    Default Re: Urgent help - Replace comma by dot

    Sheet1

     ABC
    1AAAA4,24.2
    2BBBB0,50.5
    3CCCC3,53.5

    Spreadsheet Formulas
    CellFormula
    C1=SUBSTITUTE(B1,",",".")
    C2=SUBSTITUTE(B2,",",".")
    C3=SUBSTITUTE(B3,",",".")


    Excel tables to the web >> Excel Jeanie HTML 4

    Copy down as needed and then copy -> paste special -> values
    Download an HTML Maker to show your data, and please wrap all code in [code][/code] tags so we can read it. My mind-reading add-in is on my other computer.

  3. #3
    Board Regular shemayisroel's Avatar
    Join Date
    Sep 2008
    Location
    Sydney - Australia
    Posts
    1,859

    Default Re: Urgent help - Replace comma by dot

    Do a find/replace?

    Highlight area in question, Ctrl F, replace tab etc...
    enercheenhologoskaihoogosenprostontheonkaitheosenhologosnarchhnoogovkailogohnprvtonqeonkaiqeovhnologov

  4. #4
    New Member
    Join Date
    Jan 2009
    Posts
    38

    Post Re: Urgent help - Replace comma by dot

    Hi sal/ shemay,

    I want it automated. The first table is in a workbook if i export it to other workbook the changes I indicated should be made. Kindly help with a formula

  5. #5
    New Member
    Join Date
    Jan 2009
    Posts
    38

    Post Re: Urgent help - Replace comma by dot

    Hi sal/shemay,

    Also help me in the below..

    Applicationsvalues
    AAAA4.2
    BBBB0.5
    CCCC3.5

    DDDD REFER AAAA
    EEEE REFER BBBB

    In the above Values column, for DDDD and EEEE the values are lilke refer to AAAA and BBBB respectively.

    I want the above table like

    Applicationsvalues
    AAAA4.2
    BBBB0.5
    CCCC3.5

    DDDD 4.2
    EEEE 0.5

    with the values replaced and referred....

  6. #6
    MrExcel MVP
    Join Date
    Aug 2004
    Location
    Tokyo, Japan
    Posts
    16,995

    Default Re: Urgent help - Replace comma by dot

    vannan86

    Stick on the original thread for the above.******** type=text/javascript> vbmenu_register("postmenu_1837149", true); *********>

  7. #7
    New Member
    Join Date
    Jan 2009
    Posts
    38

    Post Re: Urgent help - Replace comma by dot

    Hi jindon,

    The formula should look for REFER and it should take values appropriately and replace in that plave...

  8. #8
    MrExcel MVP
    Join Date
    Aug 2004
    Location
    Tokyo, Japan
    Posts
    16,995

    Default Re: Urgent help - Replace comma by dot

    Did you understand what I meant ???

    You are not allowed to ask the same question in multiple threads.
    It's a forum rule.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com