Closed Thread
Results 1 to 6 of 6

Urgent help needed- search and replace (finden und ersetzen) somehow doesn't work properly

  1. #1
    Registered User
    Join Date
    11-18-2012
    Location
    Cologne, Germany
    MS-Off Ver
    Excel 2007
    Posts
    2

    Urgent help needed- search and replace (finden und ersetzen) somehow doesn't work properly

    Hey guys,

    I have a dataset which I want to save as .csv file to open it later with stata. To indicate decimal numbers, in this set commas are used instead of dots. Because stata gets confused with commas I need to convert all commas to dots- with find and replace- which usually works. But now it doesn't- no idea why not.
    Does anyone of you has an idea?
    Excel always puts "########" instead or puts a dot behind the whole decimal number. I already tried a lot- saving the data as standards, numbers, text etc.
    (My Excel is German, so maybe it's called a bit different at yours- but all in all it should be the same I guess)

    I would really much appreciate your help,

    Julia

  2. #2
    Registered User
    Join Date
    06-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Urgent help needed- search and replace (finden und ersetzen) somehow doesn't work prop

    Is any of your data formatted? Is your text bolded (fettdruck)? Do you have any formulas behind the text in your cells?

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,847

    Re: Urgent help needed- search and replace (finden und ersetzen) somehow doesn't work prop

    KSSLR: This thread is seven months old...
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    06-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Urgent help needed- search and replace (finden und ersetzen) somehow doesn't work prop

    Sometimes old posts still need solving... :-)

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,847

    Re: Urgent help needed- search and replace (finden und ersetzen) somehow doesn't work prop

    That's only true if the OP is still asking for help. Further, the thread is no place for such a conversation, please stop.

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Urgent help needed- search and replace (finden und ersetzen) somehow doesn't work prop

    This OP has not been here in over 6 months. Closing this thread.

Closed Thread

Thread Information

Users Browsing this Thread

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

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