How to force a C/R within a "Wrapped" cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

XL 2000 & 2003

I would like a single cell to have:
____________
|Voucher |
|No. |
-----------------
The challenge is that the column width is too wide (and it must stay that
way)
to force a "wrap".

Therefore, I have been attempting to add a C/R like a "Chr(10)" after the
word
"Voucher".

Any thoughts?

TIA Dennis
 
Dennis said:
XL 2000 & 2003

I would like a single cell to have:
____________
|Voucher |
|No. |
-----------------
The challenge is that the column width is too wide (and it must stay
that way)
to force a "wrap".

Therefore, I have been attempting to add a C/R like a "Chr(10)"
after the word
"Voucher".

Any thoughts?

TIA Dennis
Click to expand...

Hi Dennis,

Type:

V O U C H E R Alt-Enter N O

Getting the capitalisation correct of course.

HTH,

Alan.
 
Can you just add spaces to make it wrap?
Voucher No.

This shows on my excel as
Voucher
No.
 
Back
Top