View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BatmanFromOz BatmanFromOz is offline
external usenet poster
 
Posts: 2
Default Stripping characters from strings and writing contents to another

Hi

I am new to Visual Basic, but I have a worksheet with the following text in
one cell of each row. I would like to strip out the first number and place in
another cell to the right, then strip out the second number and place in it's
own cell on the right as well. Repeat the process for each row.

Wk17 to Wk21
Wk17 to Wk21
Wk17 to Wk21
Wk2 to Wk21
Wk17 to Wk21
Wk17 to Wk21

Any ideas? Thanks in advance for your help.

Adam