Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to copy a formated paragraph in word, with SHIFT Enter. This
text also has BOLD, and underline text in it. I want to copy this to a single cell -- retaining the same format (i.e. bold and underline) as well as change the SHIFT ENTER characters to ALT ENTER. If I do a Copy from Word, after selecting the paragraph, and paste it into Excel -- all the SHIFT Enter goes to new lines in Excel. I have tried to first copy this over to Word, change all the SHIFT Enter's to ALT Enter, and then paste to Excel -- but I either lose the format, or I get back the multiple lines. Reading some posts suggested that I convert all the SHFT enter's to $$$, and then in Excel Replace the $$$ with ALT ENTER. Problem is, I lose the formating, or everthing goes to plain text. Is there a way to copy a paragraph to Excel -- retaining the same format? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
lose formatting (border) in excel cell after pasting from word | Excel Discussion (Misc queries) | |||
Pasted text from Excel to Word replaces previous paragraph | Excel Programming | |||
Formating, paragraph marks, boxes etc, how do I get rid of them? | Excel Discussion (Misc queries) | |||
Can not see all of a pasted paragraph from Word in a cell. | Excel Discussion (Misc queries) |