Hi Everyone,
I am pretty inexperienced when it comes to using Excel thus the reason i joined this forum.
Can someone please help? I am trying to seperate 2 parts of one cell.
So basically this cell (AUTPT - A1 Telekom Austria AG), i would like to split into 1 cell being AUTPT and the other being A1 Telekom Austria AG.
Is it possible for someone to provide me with a forumala for this?
thanks in advance all
Last edited by Jeshen; 12-20-2011 at 10:42 AM.
Hi and welcome to the board.
Please have a look at our rules about thread titles. In your case " Splitting cell contents" would be more descriptive than " separation". Please amend your thread title - Thx
With your data in A2 down
In B2
In C2
=LEFT(A2,FIND(" - ",A2,1)-1)
=MID(A2,FIND(" - ",A2,1)+LEN(" - "),255)
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.
Or use Data Text To Columns, use space as separator then delete the column that contains the hyphen
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
@ Special-K
Will that not split all the words into seperate columns?Or use Data Text To Columns, use space as separator then delete the column that contains the hyphen
Indeed. Using the - as separator would be much betterOriginally Posted by Marcol
@ Arthur
And that will yield a traling space in the first cell, and a leading space in the second.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Jeshen 
Register To Reply
Bookmarks