Excel2003 find replacement cell content format change!-CodePudding

Consult everybody, to Excel in the cell to find the replacement after the content of the batch, the format of the content within the cell happened don't want to change, how to avoid this kind of thing happen? ! My replacement will unit can content the @ character is replaced by a newline character, make the content of the branch in the cell,

CodePudding user response:

Please send your watch is others? If is is likely to be compatibility issues, update to the same version

CodePudding user response:

reference 1st floor everyle response:

is others send your watch? If is is likely to be compatibility issues, update in a same version

Not, comes from the WORD form in duplicate content, in the original WORD form and content have line breaks, I will replace the way a newline transformed into "@", in the bulk copy to EXCEL spreadsheets (in EXCEL spreadsheet content still retains the original content format in WORD forms, including, subscript, font, etc.), then I need to put @ replace newline symbol, and the format of the content changed (subscript, font, etc have changed).

CodePudding user response:

refer to the second floor hudemingmisteryang response:

Quote: refer to 1st floor everyle response:

Please send your watch is others? If is is likely to be compatibility issues, update in a same version

Not, comes from the WORD form in duplicate content, in the original WORD form and content have line breaks, I will replace the way a newline transformed into "@", in the bulk copy to EXCEL spreadsheet (in EXCEL spreadsheet content still retains the original content format in WORD forms, including, subscript, font, etc.), then I need to put @ replace newline symbol, and the format of the content changed (subscript, font, etc have changed),

WORD and EXCEL is 2003,