Hi,
I got a excel sheet with three columns and dynamic number of rows..
column(A) column(B) column(C) column(D)
123 "abc,1,2,3,4,b5" 23456 99999
123 "cde,3,4,b5" 23456 00000
123 "ghi,2,3,4,b5" 23456 00000
i am struggling to split COLUMN(b) text and move into new columns next to column(D).
Note: I got multiple excel files which are almost similar in nature but number of rows varies from file to file.
Please can someone help with somekind of macro or function, which i can automate this process.
Many thanks,
Sohail
Bookmarks