 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Merge cells with new line
Using Excel 2007 I have a street address in one cell and city/state/zip in another cell. I want to merge those cells and include the new line code so that they will print out correctly. Iused the concatenate function to create one line of text with a unique sequence of characters when I want the new line code. When using the "find and replace" function, what do I type into the "replace with" box to get a new line? Type Ctrl-enter in the replace box where you want the line feed to be Eddie > *From:* "BK" <nospam@nospam.com> > *Date:* Tue, 29 Apr 2008 13:23:11 -0500 [quoted text clipped - 9 lines] > "find and replace" function, what do I type into the "replace with" box > to get a new line? Nope. First of all it is ALT+ENTER that creates a new line, but I am unable to put that into the "replace with" box. I think there is some character code for ALT+ENTER, but I cannot remember it or find it anywhere. > Type Ctrl-enter in the replace box where you want the line feed to be > [quoted text clipped - 13 lines] >> "find and replace" function, what do I type into the "replace with" box >> to get a new line? CTRL + j Or Alt + 0010(on numpad) Gord Dibben MS Excel MVP >Nope. First of all it is ALT+ENTER that creates a new line, but I am unable >to put that into the "replace with" box. I think there is some character [quoted text clipped - 17 lines] >>> "find and replace" function, what do I type into the "replace with" box >>> to get a new line? Seems as though the CTRL+J combination puts an undecipherable character in the cell rather than a new line. However, I did play around a little bit. I pasted my cells into Word, converted table to text, replaced the paragraph mark with a unique character set (qzzq) and pasted back into Excel. Then I did a find qzzq and replace with CTRL+J and it worked. A little convoluted, but at least it beats manually retyping. > CTRL + j > [quoted text clipped - 24 lines] >>>> "find and replace" function, what do I type into the "replace with" box >>>> to get a new line? Hi, In order for the Ctrl+j to work, you have to format the cell to Wrap Text. Otherwise you will just get a little box between your data, and no second line. Regards - Dave TA-DA!!! Forgot to format the cell to wrap text. Thank you so much. > Hi, > In order for the Ctrl+j to work, you have to format the cell to Wrap Text. > Otherwise you will just get a little box between your data, and no second > line. > Regards - Dave You can use ctrl-j or alt-0010 (use the numbers on the numeric keypad--not the numbers above the QWERTY keys). > Nope. First of all it is ALT+ENTER that creates a new line, but I am unable > to put that into the "replace with" box. I think there is some character [quoted text clipped - 17 lines] > >> "find and replace" function, what do I type into the "replace with" box > >> to get a new line?  SignatureDave Peterson Nope! I replaced "a" with "a<ctrl-enter>b" First, I typed "a b" in the Replace box Then I highlighted the space between Then I pressed Ctrl-Enter Then I pressed Replace All Voila! Eddie > *From:* "BK" <nospam@nospam.com> > *Date:* Tue, 29 Apr 2008 14:48:19 -0500 [quoted text clipped - 21 lines] > >> "find and replace" function, what do I type into the "replace with" box > >> to get a new line? The trick seems to be to remember to format the cell to wrap text. makes a big difference. > Nope! > [quoted text clipped - 36 lines] >> >> box >> >> to get a new line?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.