jenrique.cerda
Board Regular
- Joined
- Sep 22, 2006
- Messages
- 53
Hi, I´ve got a problem here.
I have a column where cells are classified as No-35 2N ,etc. The NO- is fixed and the only thing that is variable here is the weeknumber in this case the 35 is the week number. The 2N stands for second notice, if there is a third notice I would put No-35 3N etc. If there is no notice I would put No-35 or if I notified another week it would be No-36...
I have a column with lots of week numbers; 2N, 3N, 4N, 5N, etc. Is there a way in which I can extract only the weeknumber from the cell???
In a No-37 3N I´d like to have only the 37 as a value.
In advance for your help thanks.
I have a column where cells are classified as No-35 2N ,etc. The NO- is fixed and the only thing that is variable here is the weeknumber in this case the 35 is the week number. The 2N stands for second notice, if there is a third notice I would put No-35 3N etc. If there is no notice I would put No-35 or if I notified another week it would be No-36...
I have a column with lots of week numbers; 2N, 3N, 4N, 5N, etc. Is there a way in which I can extract only the weeknumber from the cell???
In a No-37 3N I´d like to have only the 37 as a value.
In advance for your help thanks.