Using Find & Replace to insert line breaks (CTRL+J) erases cell contents

%3CLINGO-SUB%20id%3D%22lingo-sub-2686109%22%20slang%3D%22en-US%22%3EUsing%20Find%20%26amp%3B%20Replace%20to%20insert%20line%20breaks%20(CTRL%2BJ)%20erases%20cell%20contents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2686109%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EFirst%20of%20all%20thank%20you%20for%20reading%20my%20post%2C%20I%20am%20kind%20of%20desperate%20right%20now%20LOL.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20had%20to%20paste%20English%20text%20from%20Excel%20into%20Word%20in%20order%20to%20translate%20it.%20The%20Excel%20text%20is%20really%20long%20and%20has%20lots%2C%20and%20lots%20of%20line%20breaks.%20So%20when%20I%20pasted%20into%20Word%20the%20format%20was%20maintained%20with%20regards%20to%20the%20number%20of%20cells%20and%20the%20line%20breaks.%20But%20now%20when%20I%20paste%20this%20translated%20Word%20text%20back%20into%20Excel%20each%20line%20break%20is%20generating%20a%20different%20cell.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EIn%20the%20past%20I've%20used%20the%20CTRL%2BJ%20solution%2C%20involving%20replacing%20the%20line%20breaks%20in%20Word%20with%20a%20character%20that%20doesn't%20appear%20elsewhere%20in%20the%20text%20(I've%20used%20****)%2C%20pasting%20this%20into%20Excel%2C%20and%20then%20using%20Find%20%26amp%3B%20Replace%20in%20Excel%20to%20find%20all%20of%20the%20****%20and%20replace%20with%20a%20line%20break%2C%20which%20used%20to%20be%20CTRL%2BJ%2C%20but%20now%20this%20is%20just%20erasing%20all%20of%20the%20cell%20contents.%20I%20don't%20know%20what%20to%20do%2C%20does%20anyone%20have%20any%20idea%20about%20why%20this%20is%20happening%3F%20This%20used%20to%20work!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%20so%20much%20in%20advance.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ELulu%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2686109%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2686257%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Find%20%26amp%3B%20Replace%20to%20insert%20line%20breaks%20(CTRL%2BJ)%20erases%20cell%20contents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2686257%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1137796%22%20target%3D%22_blank%22%3E%40lulu01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20*%20is%20a%20placeholder%20for%20anything.%20By%20replacing%20anything%20with%20CTRL-J%20you%20are%20left%20with%20CTRL-J..%3C%2FP%3E%3CP%3EJust%20use%20something%20else%20like%20zzzz%20or%20%24%24%24%24.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

First of all thank you for reading my post, I am kind of desperate right now LOL.

I had to paste English text from Excel into Word in order to translate it. The Excel text is really long and has lots, and lots of line breaks. So when I pasted into Word the format was maintained with regards to the number of cells and the line breaks. But now when I paste this translated Word text back into Excel each line break is generating a different cell.

In the past I've used the CTRL+J solution, involving replacing the line breaks in Word with a character that doesn't appear elsewhere in the text (I've used ****), pasting this into Excel, and then using Find & Replace in Excel to find all of the **** and replace with a line break, which used to be CTRL+J, but now this is just erasing all of the cell contents. I don't know what to do, does anyone have any idea about why this is happening? This used to work!

Thanks so much in advance.

Lulu

2 Replies

@lulu01 

The * is a placeholder for anything. By replacing anything with CTRL-J you are left with CTRL-J..

Just use something else like zzzz or $$$$.

 

You could try pasting back into the formula bar, as opposed to the cell.
There, the Ctrl/J should be interpreted as wrapped text rather than a new cell.