cell format

J

Joe Bannister

Hello,

Can anyone help?

If i export from Access to Excel i can get the cell in
Excel to look like this:

Joe Bannister
123 Holly Lane
Spa
England

The cell format is general with wrap text.

Does anyone know how to do this in Excel without
exporting from Access? I've tried wrapping text,
different formats etc but nothing works.

One thing i did notice is that when i right clicked the
cell and chose format cells the content of the cell was
the whole text but with square boxes seperating the parts
as above.

Any help appreciated.

Cheers

Joe
 
G

garfield-n-odie

If you're trying to type more than one line in the same cell, press Alt+Enter
at the end of a line to start a new line in the same cell. You can probably
set the row height to automatic, but you'll probably have to set the column
width manually to fit the longest line.
 
Top