View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dagonini Dagonini is offline
external usenet poster
 
Posts: 18
Default Splitting a cell in a macro?

I have a column of cells that I would like to be able to split
automatically the problem is that there are two possible choices. The
cells begin with either Plan A or Plan B. I need to split Plan A
after 17 characters and Plan B after 25 characters.

Is there a way to write a bit of code that would be able to
differentiate Plan A and Plan B in Column C and split them so that
Plan A and Plan B stay in Column C but the other bit...0/7 or 30/30
moves into column D?

Thanks for any help in advance.