View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greg Greg is offline
external usenet poster
 
Posts: 11
Default Split cell with comma, into new worksheet

Hi

I am trying to do a text - column format but to pull into a new sheet.

e.g.

In DWH Dump A13 = Nokia, 6230

I want it to pull 'Nokia' into Sheet 1 A11 and '6230' into Sheet 1 B11.

If you can help, I would be grateful.

Many Thanks,

Greg