LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
ktjo2
 
Posts: n/a
Default 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!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Automatic Data Validation drop down creation Buddhapenguin Excel Discussion (Misc queries) 1 May 12th 05 08:41 PM
Timeline: where it will match up data automatically Fidelio1st Excel Discussion (Misc queries) 0 March 5th 05 06:27 PM
Automatically pull data into another worksheet within the same fil TJess Excel Worksheet Functions 1 November 15th 04 08:00 PM
getting data from 2 excel sheets automatically pinar Excel Worksheet Functions 0 November 9th 04 11:47 AM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"