Hi

I have excel sheet ... in excel sheet every time i copy & paste in data have some ticket in one row in this format TE8Q52444686(B),TE8Q73554834(B),TE8Q63695559(B),TE8Q39393283(B) the i use delimited and arranging row wise. every time ticket count and quantity not fix if possible automation macro for that ...