Separate multiple words within a cell
My spreadsheet combined all words within a title when I copied it over from an article. Is there a way to separate each word correctly within the cell?
TheKeeperofLostCauses - I want it to read The Keeper of Lost Causes and still keep it in the one cell.
Thank you
almost, if all the words started with a capital letter yes there would be.
When copying from an article, it should preserve the spaces between the words, then you could use Text To Columns. Given the example you've shown, however, as rcm notes if not all words are uppercase then there is no reliable way to break the words up.
Where are you copying the title from? There might be a better way to do the copy & paste.
Moderator's note: Looks like an Excel question, moved from "Word Formatting & General" --6StringJazzer
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
O.K. I fixed all words to start with a capital letter.
Any help would be appreciated.
Thanks
I fixed all words to start with a capital letter.
Any help would be appreciated.
Thanks
I still think we need to look at the whole problem. I asked above where you are copying titles from. There might be a better way to do the copy & paste.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks