Add accents?

Solved
cecile-helpp Posted messages 11 Status Member -  
cecile-helpp Posted messages 11 Status Member -
Hello,

I exported data from the Cindoc software to Excel. They are all in uppercase in Cindoc, and therefore also in Excel. Thanks to the "lowercase" and "proper case" functions, I was able to convert the text to lowercase, but the accents are nowhere to be found. However, it's a large file. I wanted to know if you knew of a way to automatically revert the uppercase to words?
These data are then exported to Word, in case you have a solution for doing it here as well.

Thank you.

Cécile

5 answers

  1. Le Pingou Posted messages 12274 Registration date   Status Contributor Last intervention   1 476
     
    Hello,
    If the Excel data will be exported to Word in uppercase, you simply need to import them directly from Cindoc to Word as they are (uppercase on Cindoc).

    --
    Regards.
    The Penguin
    0
  2. JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
     
    Good evening,

    I suppose you meant to say "how to automatically add accents to the words" and not uppercase letters.

    If your formulas for converting to lowercase or proper case have been overwritten by a copy/paste value, you might consider using Excel's spell checker.
    It won't work miracles, but it can make your work easier.

    You can launch it by pressing <f7> or through the Review/Spelling tab.

    Best regards</f7>
    0
  3. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    ... and why go through Excel?
    Is it not possible to import directly from Cindoc to Word?

    --
    Retirement is great! Especially in the Caribbean ... :-)
    Raymond (INSA, AFPA, CF/R)
    0
  4. cecile-helpp Posted messages 11 Status Member
     
    Yes, sorry, I meant accent and not uppercase; if I’m also writing nonsense..!

    Okay, I will do it using F7 then. In Word, it’s the same, only with the spell checker, there isn’t a "magic method" possible?

    For what we want to do, we have to go through Excel before Word, yes..

    And on Cindoc everything is filled in uppercase, so I have no choice but to export in uppercase and then transform it afterwards.

    Thank you

    Cécile
    0
  5. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    So aside from hiring temporary workers or assigning this task to trainees in office automation, I see no solution, especially not an automatic one!

    --
    Retirement is great! Especially in the Caribbean... :-)
    Raymond (INSA, AFPA, CF/R)
    0
    1. cecile-helpp Posted messages 11 Status Member
       
      Alright, never mind then :)

      Thank you for the answers!
      0