• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

how to break a very long word when it is longer then the cell width prvided?

New Here ,
Mar 07, 2008 Mar 07, 2008

Copy link to clipboard

Copied

hi I have problem finding a solution to detect and break the sentence with no space or break in between when it reach the end of the cell width.

Example:
-----------

AVeryLongWordLikeThisAVeryLongWordLikeThisAVeryLongWordLikeThisAVeryLongWordLikeThisAVeryLongWordLikeThisAVeryLongWordLikeThisAVeryLongWordLikeThisAVeryLongWordLikeThisAVeryLongWordLikeThisAVeryLongWordLikeThis


how can I detect and break this so it didn't break my layout.
TOPICS
Advanced techniques

Views

190

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 07, 2008 Mar 07, 2008

Copy link to clipboard

Copied

LATEST
As long as the caps are there, you can get their ascii values with the asc() function and put a space before each one, or whatever you think you want to do.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation