G Guest Mar 1, 2007 #1 how do I edit narrative entries in an excel spreadsheet format? I.e. how do I get words to hyphenate automatically in cells?
how do I edit narrative entries in an excel spreadsheet format? I.e. how do I get words to hyphenate automatically in cells?
J JE McGimpsey Mar 1, 2007 #2 XL isn't a word processor - there's no built-in functionality for automatic hyphenation. XL knows nothing about words, punctuation, etc. In theory it could be done with event macros, but if you're looking for hyphenation at syllabic borders, they would have to be rather sophisticated.
XL isn't a word processor - there's no built-in functionality for automatic hyphenation. XL knows nothing about words, punctuation, etc. In theory it could be done with event macros, but if you're looking for hyphenation at syllabic borders, they would have to be rather sophisticated.
G Gord Dibben Mar 1, 2007 #3 Excel is not a word processing program. Consequently it is lacking many of the functions of a WP program. Editing is as simple as hitting F2 and adding/deleting text in the formula bar. Hyphenation would be more difficult and complex. Suggest you use Word for editing then copy the results back to Excel if necessary. Gord Dibben MS Excel MVP On Thu, 1 Mar 2007 14:51:07 -0800, cjol in WA <cjol in
Excel is not a word processing program. Consequently it is lacking many of the functions of a WP program. Editing is as simple as hitting F2 and adding/deleting text in the formula bar. Hyphenation would be more difficult and complex. Suggest you use Word for editing then copy the results back to Excel if necessary. Gord Dibben MS Excel MVP On Thu, 1 Mar 2007 14:51:07 -0800, cjol in WA <cjol in
