LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 28
Default How does an address appear to have 2 fields in 1 - see sample

Sorry to correct the correction and I know this News group is Excell when Alt
Enter adds a line feed but the subject is Access in which case its Ctrl Enter
not Alt Enter as previous poster states. (Don't believe me? Try it in Access)

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Gord Dibben" wrote:

Make that Alt + Enter, not CTRL + Enter


Gord Dibben MS Excel MVP

On Sat, 15 Nov 2008 08:48:00 -0800, MikeJohnB
wrote:

By the way, this can be proved by pressing delete at the end of the first
visible line, the line feed will be deleted and the text will then appear on
the same row. Place the cursor at the end of the first line of text (where is
used to be) and press controle enter. The text will again appear on two lines

Regards



 
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
how can I convert data with fields in rows to fields as columns PiyushAg Excel Discussion (Misc queries) 3 July 2nd 07 05:46 AM
Address is in separate fields Jen96 Excel Worksheet Functions 2 December 14th 05 01:50 PM
How do I take some of my Excel fields and make address labels? Carmen Excel Discussion (Misc queries) 1 September 19th 05 05:20 PM
How to post sample data to this NG M.Siler Excel Discussion (Misc queries) 12 June 27th 05 11:37 PM
Can't get Outlook to recognize address card fields when importing. eointfinn Excel Discussion (Misc queries) 0 February 6th 05 01:09 AM


All times are GMT +1. The time now is 05:38 AM.

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"