View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
MikeJohnB MikeJohnB is offline
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