User Profile
g-00000
Copper Contributor
Joined Mar 12, 2024
User Widgets
Recent Discussions
Re: How to replace without destroying formatting and in-cell-linebreak?
https://filetransfer.io/data-package/BFBuo9vI#link Thx for the link. What I mean linebreak is the alt+enter linebreak, like Aaaaaaaa aaaaaaaa aaaaaaaa (Three lines because I clicked enter) not wrap like Aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa (Many “lines” because of being too long) I’ve set wrap in the question’s file.Re: How to replace without destroying formatting and in-cell-linebreak?
peiyezhu Want to upload file, but this website says "The file type (.xlsx) is not supported". I'll describe by text: Line breaks are alt+enter. In the question's file, line breaks were made through =D1&CHAR(10)&"例："&E1&CHAR(10)&"近："&F1&CHAR(10)&"派："&G1 After combining the previous cells together, I added formatting manually.How to replace without destroying formatting and in-cell-linebreak?
I want what in the red circle. Using replace in excel destroys formating. Using replace in word doesn't destroy formating, but pasting back to excel destroys linebreaks in one cell (alt+enter), making each line be in a single cell, even if these linebreaks are manual linebreaks (^l) instead of paragragh marks (^p). HOW TO DESTROY NOTHING?Re: How to replace without destroying formatting and in-cell-linebreak?
The excel’s suitable function is making the window 3x1, leaving one row and three columns shown. If recognizing the word, then press enter to go to the next row; if not, go to the fourth column to see the explanation, and type “1” in the third column, then go back to the left end, then go down to the next row. After finishing one turn, sort the third column to make rows with “1” be at the top, so they can be reviewed with priority. If still not recognized, change “1” to “2”, so sorting again makes rows with “2” be at the top, then rows with “1”, then words recognized.
