Copy/Paste to a new workbook and perform the action there. You have two options:ġ) You can do what you already suggested. Unfortunately Find/Replace in MS Office just isn't this smart. Didn't work-never got that far- I couldn't paste the column into a new worksheet to work on it there.Īny help would be vastly appreciated. I tried to cut out the column I wanted to restrict the action to with the plan of pasting it into a new worksheet as a single column, hoping to use FIND and REPLACE on it there, with no other columns to disturb, and hoping to cut out the altered column and paste in back into the original spreadsheet, having no other columns disturbed. I have tried selecting just the cells in one column but the action still seems to extend throughout the spreadsheet. The trouble is, how do I restrict this action to just one column leaving cells containing the text fragment in neighboring columns unchanged? Every time I try to apply FIND and REPLACE it eliminates the text fragment EVERYWHERE that fragment occurs in the worksheet. This should be simple but I'm having trouble with it even so: I want to FIND a short piece of text at every one of its occurrences in one column, and REPLACE it with nothing, leaving the text in every cell which has been altered in that column otherwise intact.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |