line break

I have a spreadsheet with address information, with columns for Address Line 1, Address Line 2, City, State, and ZIP. I'd like to combine each of the columns into a single, formatted column, with line breaks in the address as follows: Address Line 1 (break) Address Line 2 (break) City, State...

Dear All, I have a cell where I am stringing text together and want to force a line break/carriage return in the label. I know that if I was purely entering text, I can hit ALT+Enter within the text to force a line break. How do I accomplish this when the text is created using concatenation...

Hi guys, I'm creating a template in excel to automate an e-mail that has to be sent out to different customers. I'm pretty much just using the ''&'' function to add individual information to generic text. What I would like to do is have it start off like this: ''Dear Mr. Brown, Please find...

Hey guys, I'm having problems with formatting. I'm trying to get text to go to the line below in a merged cell, to no avail, and was wondering if anyone could help. :)

Hello Excel Experts! I have filled a custom CommandBar in Excel 2007 with like 10 control elements. However, these controls are positioned in a single row by Excel on CommandBar creation. Is there a way to wrap the line of controls at determined positions? I have tried the .Width property of...

Problem: When linking a single cell from Excel 2003 to Word 2003 I'm getting a forced line break right after the linked cell data. Example: The vacancy rate was 4.5% in the Western U.S., while it was 2.5% in California. There are line breaks after 4.5% and 2.5% that should not be there. My...

Hi all, I've been using the forums for several days to get answers to my questions but finally came across a dead end. Please help! I'm working with a dataset where there is a whole bunch of text in one cell that I need to parse. There are two delimiters: "~" and ";". Furthermore, there are...

Hi there I was looking for a way to paste data from Word into Excel, and found several posts on the topic (e.g. http://www.mrexcel.com/forum/showthread.php?t=337939 or http://www.mrexcel.com/forum/showthread.php?t=221306). However, I didn't find any explanation on what the ASCII character...