View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nagesh Nagesh is offline
external usenet poster
 
Posts: 11
Default Split values in one cell and place them in different cells

I have a value say @Sum([aa] [bb] [cc] [dd] [ee]) in cell A1.
I want to place the cursor in cell A2 and run a function which will remove
the brackets and place the values in cells as follows:
A2- aa
A3- bb
A4- cc
A5- dd
A6- ee

Thanks, Nagesh