If you set the tool to split the text as "fixed width," then it doesn't split words at spaces it just makes sure that each chunk is whatever size you specify. If you set the tool to split text based on delimiters such as a space, then you end up with a single word in each cell. You might think you could use the Text to Columns tool in Excel, but it is not suited well for the job. But he wants to make sure that the split is made at the space before the 12th character, rather than at the exact 12th character. For instance, if a cell contains "the quick brown fox" and he needs to split the text so that no part is longer than 12 characters, Phil can easily do it. Some of the text is too long, so he needs to split it into multiple cells. Phil has a series of cells that contain text.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |