ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Stop text from stringing into next field when empty (https://www.excelbanter.com/excel-worksheet-functions/26203-stop-text-stringing-into-next-field-when-empty.html)

NothingButRomance

Stop text from stringing into next field when empty
 

When I have a "sentence" of text in a field and the field next to it is
empty, the sentence text strings into it and you don't see a empty
field. I know that I can change the width of the field that the
sentence is in, but that won't work in this case because I need it
small, so is there a way to stop the text from wandering into the next
field? This is not a Merge issue, by the way, Merge is not checked. I
can go into the empty field and hit the space button to make the field
before it (with the sentence) think that its not empty, but that only
works while you have it open, even if you save, the string comes back
the next time you access the file.

HELP!!
Thanks,
Lalla


--
NothingButRomance

Vasant Nanavati

Format | Cells | Alignment | Text Control | Wrap Text.

--

Vasant


"NothingButRomance" om
wrote in message on.com...

When I have a "sentence" of text in a field and the field next to it is
empty, the sentence text strings into it and you don't see a empty
field. I know that I can change the width of the field that the
sentence is in, but that won't work in this case because I need it
small, so is there a way to stop the text from wandering into the next
field? This is not a Merge issue, by the way, Merge is not checked. I
can go into the empty field and hit the space button to make the field
before it (with the sentence) think that its not empty, but that only
works while you have it open, even if you save, the string comes back
the next time you access the file.

HELP!!
Thanks,
Lalla


--
NothingButRomance




Max

Format | Cells | Alignment | Text Control | Wrap Text.
or you coudl also try the "Shrink to Fit" option under Text control

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----




All times are GMT +1. The time now is 01:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com