how do i hyphenate text in excel

[cjol in WA]

how do I edit narrative entries in an excel spreadsheet format? I.e. how do
I get words to hyphenate automatically in cells?

 

[JE McGimpsey]

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.

 

[Gord Dibben]

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