cell splitting words
How do I tell Excel not to split words within a cell? For example, I have a
cell that says: install basic software in computer fo r everyone I don't want the word "for" to be split like that. |
cell splitting words
Make the cell wider and/or insert line breaks, Alt+Enter, in front of the
word you don't want split. "Betsy" wrote in message ... How do I tell Excel not to split words within a cell? For example, I have a cell that says: install basic software in computer fo r everyone I don't want the word "for" to be split like that. |
cell splitting words
Betsy,
If you've typed that sentence into the cell, then set wrap text on (Format - Cells - Alignment), it should not be breaking up the words. Maybe there's a line break (alt-Enter was pressed) in the sentence. Try temporarily widening the column and see if it still breaks after "fo". The entire sentence should appear in one line if you've made the column sufficiently wide. The only thing that will cause line breaks in that situation is to have used Alt-Enter in the sentence. See if it's still breaking. Select the cell and look carefully at the contents of the cell. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Betsy" wrote in message ... How do I tell Excel not to split words within a cell? For example, I have a cell that says: install basic software in computer fo r everyone I don't want the word "for" to be split like that. |
All times are GMT +1. The time now is 09:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com