Good day all. I need to extract and separate the letters into their own separate columns from strings. As an example: cell A1= 25 l i jj 66 asdf. I need B1=2; C1=5; D1=l; E1=i and .... up to end of the string. I do not need spaces, So spaces must be ignored.
I preffer normal excel formulas instead of VBA or macro.
Regards.
With
A1: some text....25 l i jj 66 asdf
This regular formula begins the list of non-space characters
Formula:
Please Login or Register to view this content.
Copy that formula across to the right as far as you need.
In the above example, these are the B1:M1
Is that something you can work with?
Please Login or Register to view this content.
Dear Ron, This is exactly what i need. many thanks. I need to think more to understand how it does the extraction. Regards.
Guys! may i ask you to help with this as well?
http://www.excelforum.com/excel-prog...54#post3376554
Try this shorter, non-volatile formula for splitting your string, drag across until blanks are returned
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.
Thanks, Marcol...better
(I've got to cull the obsolete "solutions" from my formula stash. That one was just below the one I selected. :\ )
Don't we all ...
I 'm still reluctant to use IFERROR() ....
@ Marcol
Fantastic. thanks. (I love your AVATAR)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks