View Single Post
  #1   Report Post  
james
 
Posts: n/a
Default converting from text to numerical number

I have a spread sheet of entire year schedule. The format as following:

1 2 3 .... 31
row 1
row 2
row 3 Jan
row 4
row 5 Feb

row x Dec

I would like to replace column 1 up to Jan to 1. Replace the cell below Jan
to Feb to 2. etc.

Would anyone help.

Thanks in advance.