LinkBack URL
About LinkBacks
Hi Team
I have skills in cell A1 ( refer the attached sheet ). I want to split each skill in cell A1 into cell B1 , B2 , B3 and so on.
Please help me how to split these skills into column example i want as below
Delphi
AS-400
RPG
IMS
Hi Team
I have skills in cell A1 ( refer the attached sheet ). I want to split each skill in cell A1 into cell B1 , B2 , B3 and so on.
Please help me how to split these skills into column example i want as below
Delphi
AS-400
RPG
IMS
You have marked the thread as solved - is it?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
If it is NOT solved, use this:
=IFERROR(TRIM(SUBSTITUTE(MID($A$1,SUMPRODUCT(LEN($A$1:A1))-LEN($A$1)+1+MAX(0,2*(COLUMNS($A:A)-2)),FIND(",",$A$1&",",SUMPRODUCT(LEN($A$1:A1))-LEN($A$1)+2+MAX(0,2*(COLUMNS($A:A)-2)))-(SUMPRODUCT(LEN($A$1:A1))-LEN($A$1)+1+MAX(0,2*(COLUMNS($A:A)-2)))),",","")),"")
in B1, dragged across until blanks appear.
You can also have a similar formula in A2, copied DOWN, but NOT in B1 copied down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
On second thoughts... you can (nearly) get what you want:
=IFERROR(TRIM(SUBSTITUTE(MID($A$2,SUMPRODUCT(LEN($B$1:B1))+1+MAX(0,2*(ROWS($2:2)-2)),FIND(",",$A$2&",",SUMPRODUCT(LEN($B$1:B1))+2+MAX(0,2*(ROWS($2:2)-2)))-(SUMPRODUCT(LEN($B$1:B1))+1+MAX(0,2*(ROWS($2:2)-2)))),",","")),"")
BUT B1 MUST be blank, otherwise this formula will need to be a little bit more complicated!!
Hi Glenn
When i copied the formula in B1 i am able to see the first word DELPHI and also in the other cells as well in B2 and so on. Please help me to populate the other skills in from B2 to other cells.
Re-read Post 4.
I do not own a crystal ball. Unless you show me what you have done, how can I help?
Post a sample sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks