Hi,
I want to split data from worksheet 'Data' into the form of data as mentioned in 'Result' worksheet.
Hi,
I want to split data from worksheet 'Data' into the form of data as mentioned in 'Result' worksheet.
Once again you are failing to give fully representative data. What about this type of data that you told us about halfway through your last thread?
Khitwan Polythene Bag Udhyog (Calami Eng.),Pght(300010459 (Main))
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Oops.I forget to incorporate.Thanx for reminding me.
Kindly take this into consideration assuming in worksheet.
Last edited by paradise2sr; 09-27-2020 at 10:22 AM.
paradise2sr
Hello, please explain....
Plz find in attachment revised and updated including all the cases and complete data.
To explain again, I have data in one worksheet i.e in "Data".in B2 column and below.From this data I require to separate in 3 columns as mentioned in another expected worksheet i.e namely-"Result".
The file is also presented in a manner that it is in self explanatory.
Last edited by paradise2sr; 09-27-2020 at 10:50 PM.
In C2
=IFERROR(LEFT(B2,IFERROR(FIND(",",B2)-1,AGGREGATE(15,6,FIND({1,2,3,4,5,6,7,8,9},B2),1)-2)),B2)
In D2
=(IF(ISNUMBER(FIND(",",B2)),LEFT(MID(B2,FIND(",",B2)+1,256),FIND("(",MID(B2,FIND(",",B2)+1,256))-1),""))
In E2
=IFERROR(MID(B2,AGGREGATE(15,6,FIND({1,2,3,4,5,6,7,8,9},B2),1),9),"")
Copy down all.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thanx a lot.Could you help me in the post >>https://www.excelforum.com/excel-pro...-into-one.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks