+ Reply to Thread
Results 1 to 12 of 12

Spelling, grammar correction all at once!

  1. #1
    Registered User
    Join Date
    07-16-2016
    Location
    shenzhen
    MS-Off Ver
    2013
    Posts
    7

    Question Spelling, grammar correction all at once!

    Hi everyone,

    Glad to find this forum online! hope i can get the help i need here

    There is my problem,

    I got a file with 3500 lines and around 10 columns with many wrong spelling and wrong type on it.

    I used the 'Spelling' part to find where are all those mistakes then i realized that i can only correct and fix the mistake line by line, means it can take me so much time to repair all of those...even using the 'Auto-correct' system and the 'Change-All' it check and fix line by line.

    What i would like to do is to fix the word selected and fix all of them in the excel document file at once!
    Do you think they have any way or possibility to do it?

    seems have some macro or program do that,

    Any help with useful.
    Thanks.

    Al.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Spelling, grammar correction all at once!

    Welcome! Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-16-2016
    Location
    shenzhen
    MS-Off Ver
    2013
    Posts
    7

    Re: Spelling, grammar correction all at once!

    Thank you for the prompt reply!

    as you can see on those files, ( it is actually in french)

    when i autocorrect a word it doesnt correct for all the same word in al the file..

    i dont know why, because i did some test on an normal file it can actually change and correct the same work on the same line or column, so why it is not working on my files?

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Spelling, grammar correction all at once!

    I speak French, so that isn't an issue, luckily. However, I cannot make head nor tail of these two workbooks! Please provide a cut-down sample version that shows what you are trying to do, with examples of before and after.

  5. #5
    Registered User
    Join Date
    07-16-2016
    Location
    shenzhen
    MS-Off Ver
    2013
    Posts
    7

    Re: Spelling, grammar correction all at once!

    bonjour,

    avez vous skype? mon compte: bramsyouden

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Spelling, grammar correction all at once!

    Oui, mais ça ne va pas - désolée. Il faut continuer ici.

    Yes, but that's not acceptable - sorry. We need to continue here.

  7. #7
    Registered User
    Join Date
    07-16-2016
    Location
    shenzhen
    MS-Off Ver
    2013
    Posts
    7

    Re: Spelling, grammar correction all at once!

    Bonjour!

    There is a sample of the document,

    as i mention in the other thread, i would like to have the same idea the 'Spelling' System, mean correcting the grammar and wrong writing and correct it but i would like it correct all the words inside the file instead of correcting it only in one line.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Spelling, grammar correction all at once!

    In your sample file you need to show clearly what the BEFORE and AFTER will be.

  9. #9
    Registered User
    Join Date
    07-16-2016
    Location
    shenzhen
    MS-Off Ver
    2013
    Posts
    7

    Re: Spelling, grammar correction all at once!

    it is hard to show it, the only way for me is to explicit it

  10. #10
    Registered User
    Join Date
    07-16-2016
    Location
    shenzhen
    MS-Off Ver
    2013
    Posts
    7

    Re: Spelling, grammar correction all at once!

    There is the example:

    I click on the 'Spelling', I translate the word 'Strip' means 'Bande' in french, i click on 'ChangeAll' but if you do a reasearch for the word Strip on the File, you gone still find the words 'Strip' on the file twice, means it didn't translate all the words 'strip' inside the fil

    the first file in on my previous message, thank you

  11. #11
    Registered User
    Join Date
    07-16-2016
    Location
    shenzhen
    MS-Off Ver
    2013
    Posts
    7

    Re: Spelling, grammar correction all at once!

    @AliGW can you please check if they have any ways?

    thank you

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Spelling, grammar correction all at once!

    I am not able to help you - sorry. I don't understand what you are doing. Maybe somebody else will be able to help.

+ 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. [SOLVED] Grammar solver/name combiner
    By New2me in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2014, 11:50 AM
  2. [SOLVED] Grammar solver/name combiner
    By New2me in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-03-2014, 11:38 AM
  3. [SOLVED] Funtion Proper Grammar for Programming
    By Zealotwraith in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2013, 12:42 AM
  4. [SOLVED] Disabling Grammar & Spelling check in MS Word thru Excel
    By jdlc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2012, 01:11 PM
  5. Grammar, and standard messages
    By Pete_UK in forum Suggestions for Improvement
    Replies: 2
    Last Post: 06-06-2012, 12:45 PM
  6. Grammar checking
    By spawforths in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2011, 11:50 AM
  7. [SOLVED] Is there a grammar checker for Excel?
    By DDC in forum Excel General
    Replies: 1
    Last Post: 05-26-2005, 05:15 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