+ Reply to Thread
Results 1 to 5 of 5

How to Replace All within selected COLUMN of text?

  1. #1
    Registered User
    Join Date
    09-01-2020
    Location
    London, England
    MS-Off Ver
    Version 2007
    Posts
    3

    How to Replace All within selected COLUMN of text?

    Hello!

    Been puzzling over this for a while, trying to work it out, but Word is refusing to let me Replace All within a column of text - it just reverts to the horizontal selection.

    I need to replace 1000 lines of colons by a full stop, and if there's any way I can avoid doing that by hand I will certainly take it! Can anyone tell me what the matter is here?

    Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: How to Replace All within selected COLUMN of text?

    When you say "a column of text" is this a column within a table, or a column where the section has been formatted to have multiple columns? At what point does it revert to a horizontal selection? I would think that it would be straightforward to select the 1000 lines you want to change but maybe I'm not understanding what you're describing.

    Is the file something you can share? See yellow banner at the top for how to attach.

  3. #3
    Registered User
    Join Date
    09-01-2020
    Location
    London, England
    MS-Off Ver
    Version 2007
    Posts
    3

    Re: How to Replace All within selected COLUMN of text?

    Attachment 693440
    Attachment 693441

    Thanks for your response!
    I'm trying to replace parts of a subtitle file which is in the wrong format.
    There are two sections within each line which need altering (outlined in the first image), hence the need to select each part in separate columns (Alt+drag).
    It reverts to the horizontal selection as soon as I've pressed Replace All - I hope this is visible in the second image.

  4. #4
    Registered User
    Join Date
    09-01-2020
    Location
    London, England
    MS-Off Ver
    Version 2007
    Posts
    3

    Re: How to Replace All within selected COLUMN of text?

    I've just realised Word does not let me paste over a selected column of text to replace it, either. This is very frustrating!

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: How to Replace All within selected COLUMN of text?

    Your attachments are invalid. Please read the yellow banner and carefully follow the guide.

+ 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] Replace text for selected cells only
    By Hall in forum Excel General
    Replies: 5
    Last Post: 01-02-2021, 05:11 PM
  2. [SOLVED] Replace and delete certain text in the selected cells
    By Dunno123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-06-2020, 06:37 PM
  3. [SOLVED] VBA Macro to find text string in one column and replace specific text in another column if
    By bmahfood in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2017, 11:15 AM
  4. Replace text selected from drop down list with a number (same cell)
    By Excelbuddy_7 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-06-2015, 11:30 AM
  5. Filter column by text, then export column to new workbook, replace searched text with new.
    By Headhunter234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2015, 07:48 AM
  6. [SOLVED] Search through columns and find specific text and replace that text with header column
    By adamzee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2014, 11:59 PM
  7. Search Selected Data for a Text String and replace entire cell with new tex
    By maz003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 02:26 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