Windows 10: Search and Replace in Word and.or Excel

Discus and support Search and Replace in Word and.or Excel in Microsoft Office and 365 to solve the problem; Windows 10 and Office 365 If I have a sentence in Word and I want to change a bit of text by adding something at the end of every sentence - eg Old... Discussion in 'Microsoft Office and 365' started by Sigurd, Aug 29, 2020.

  1. Sigurd Win User

    Search and Replace in Word and.or Excel


    Windows 10 and Office 365

    If I have a sentence in Word and I want to change a bit of text by adding something at the end of every sentence -
    eg Old text. to read Old text. New text.
    I can search for the paragraph marker using ^p and replace it with " New text.^p so that Old text.^p becomes Old text. New text.^p
    My sentence is now Old text. New text.

    I want to do the same with text in cells in a Word or Excel table, but I don't know what control character to use. It's not ^p. Can anyone tell me what it is at the end of text in each cell of Word and Excel? Word shows a small circle with 4 spikes (a mini Corona!); Excel doesn't show anything.

    :)
     
    Sigurd, Aug 29, 2020
    #1
  2. Sigurd Win User

    Search and Replace in Word and.or Excel

    Thanks Berton.
    In Word you can use Find and Replace and select More then Special and there is a list of codes for Paragraph mark ^p, Manual line break ^l or Non-breaking space ^s and search for those. Using Word I could search for ^p at the end of a line of text in a cell then replace it with ^p new text^p
    What I am looking for is something similar that was at the end of the text in an Excel cell that I could use in a similar way, but I don't think there is a paragraph break at the end of a line of text in an Excel spreadsheet.
    I could convert the spreadsheet to Word, do the work there as detailed above and then convert back to Excel.
     
    Sigurd, Aug 29, 2020
    #2
  3. Sigurd Win User
    Search and Replace in Word and.or Excel

    Windows 10 and Office 365

    If I have a sentence in Word and I want to change a bit of text by adding something at the end of every sentence -
    eg Old text. to read Old text. New text.
    I can search for the paragraph marker using ^p and replace it with " New text.^p so that Old text.^p becomes Old text. New text.^p
    My sentence is now Old text. New text.

    I want to do the same with text in cells in a Word or Excel table, but I don't know what control character to use. It's not ^p. Can anyone tell me what it is at the end of text in each cell of Word and Excel? Word shows a small circle with 4 spikes (a mini Corona!); Excel doesn't show anything.
     
    Sigurd, Aug 29, 2020
    #3
  4. Berton Win User

    Search and Replace in Word and.or Excel

    Berton, Aug 29, 2020
    #4
Thema:

Search and Replace in Word and.or Excel

Loading...
  1. Search and Replace in Word and.or Excel - Similar Threads - Search Replace Word

  2. Search and Replace in Word and.or Excel

    in Windows 10 Software and Apps
    Search and Replace in Word and.or Excel: Windows 10 and Office 365 If I have a sentence in Word and I want to change a bit of text by adding something at the end of every sentence - eg Old text. to read Old text. New text. I can search for the paragraph marker using ^p and replace it with " New text.^p so that...
  3. Excel Search?

    in Windows 10 Customization
    Excel Search?: Hello, Is it possible to create a search field in Excel, where you can search for several values from a table (e.g. names) and after entering the values only the rows are displayed that were searched for? Excel Suche?
  4. Excel and Word

    in Windows 10 BSOD Crashes and Debugging
    Excel and Word: Why just out of the blue do I get this pop up when I open excel and word that says "We're sorry, but excel and word has run into an error that is preventing it from working ,,,,,, " This prevents me from working as it just closes on it's own. There is always something with...
  5. Excel, word and Powerpoint

    in Windows 10 Network and Sharing
    Excel, word and Powerpoint: I upgraded to Windows 10 but no longer have word , excel or powerpoint. I cannot open documents without these apps. How can i get them back? https://answers.microsoft.com/en-us/windows/forum/all/excel-word-and-powerpoint/c83a9936-e2e5-4e77-8546-b0b543435c3f"
  6. msointl.dll with Word and Excel

    in Microsoft Office and 365
    msointl.dll with Word and Excel: I've tried to resolve this issue and it's not working I also tried Microsoft solution and it didn't work either. Any way to fix this? This is Office 2010. Thank you [img] [img] 139067
  7. Excel Word Highlight

    in Windows 10 Customization
    Excel Word Highlight: Yellow highlight shows as green. however it prints out as yellow. also shows green on a different monitor. how do i correct this? https://answers.microsoft.com/en-us/windows/forum/all/excel-word-highlight/8b798bcd-b5a0-4bb8-b2e8-6f24b6c4c124
  8. Excel Word Highlight

    in Windows 10 Customization
    Excel Word Highlight: Yellow highlight shows as green. however it prints out as yellow. also shows yellow on adifferent monitor. how do i correct this? https://answers.microsoft.com/en-us/windows/forum/all/excel-word-highlight/60cb53d2-2341-4366-a750-28f345a560a3
  9. Using Word and Excel

    in Windows 10 Network and Sharing
    Using Word and Excel: I recently upgraded to a new computer with Windows 10 . I can't use Word or Excel. I can only look and print what is there! I can't edit or create new documents like I could with Windows XP. I don't really think I improved my computer if I can't use these programs. Help...
  10. WORD/EXCEL DISAPPEARED

    in Windows 10 Installation and Upgrade
    WORD/EXCEL DISAPPEARED: I just recently reinstalled my Windows 10 and now I can not find Word, Excel or any other Office applications on my computer. I have been using Windows 10 for a couple of years now, after upgrading Windows 7. This is the second time I reinstalled my windows and it's the...