Thread: How does an address appear to have 2 fields in 1 - see sample data
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How does an address appear to have 2 fields in 1 - see sample
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

Reply With QuoteReply With Quote