Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automatically drop data to next line
I have a cell that looks like this
John Doe 123 N. 1st Street Miami, FL 12345 Is there a formula, or something I can do to get it to look like this John Doe 123 N. 1st Street Miami, FL 12345 Without having to go through and press enter and resize all of the column widths. I swear I've seen something that looks like a little box that you can put between things in a cell that will make it automatically drop to the next line. Thanks!! |
#2
|
|||
|
|||
Hi Excel can do this in a round-about way, but it needs to know where you want the line breaks. If your cell said John Doe, 123 N. 1st Street, Miami FL 12345 You could use text to columns to split the cell into three and then concatenate back into one by using =a1&char(10)&b1&char(10)&c1 Hope this helps Colin -- Colin Vicary ------------------------------------------------------------------------ Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472 View this thread: http://www.excelforum.com/showthread...hreadid=395017 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
Timeline: where it will match up data automatically | Excel Discussion (Misc queries) | |||
Automatically pull data into another worksheet within the same fil | Excel Worksheet Functions | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |