Can 'text to columns' or 'split' function be applied to a cell containing a line of alphabets that has nothing to separate each alphabet?
For example, ABCDEFGHIJ (although not in this order) instead of A B C D E F G H I J
I tried but didn't work
Or if there's a way to separate the alphabets into rows, that's good, too.
affj, how about using the Fixed width option in Text to Columns? You'll need to click once between each letter, but they'll then all be separated.
Hope this helps.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
This dragged across will split the string into columns
Formula:
Please Login or Register to view this content.
This dragged down will split the string into rows
Formula:Please Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thank you very much!
Do you happen to know a code that can split a number sequence every 2 numbers, too?:
from; 6748398756364767472829
to; 67 48 39 87 56 36 47 67 47 28 29
Try these
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks