| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
