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
    12,594

    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
    12,594

    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
    Forum Expert 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.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

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