Hi there,
On excel I have a cell which simply reads "BBBC" is there any way I can split this so that I have 4 cells each with only 1 value in. "B" "B" "B" "C", the reason why I can't just type those in because it needs to be automatically taken from the BBBC part, annoying - yes.
Similarly, or not so similarly I have the following, (in the grade summary I have crudely done Cell2&Cell3&Cell4... to simplify this.
All I need to do is take either the original grades and be able to put them somewhere else in separate cells or the "BBBC" part, any help will greatly be appreciated! Google isn't helping me as I'm not that specific.
On excel I have a cell which simply reads "BBBC" is there any way I can split this so that I have 4 cells each with only 1 value in. "B" "B" "B" "C", the reason why I can't just type those in because it needs to be automatically taken from the BBBC part, annoying - yes.
Similarly, or not so similarly I have the following, (in the grade summary I have crudely done Cell2&Cell3&Cell4... to simplify this.
All I need to do is take either the original grades and be able to put them somewhere else in separate cells or the "BBBC" part, any help will greatly be appreciated! Google isn't helping me as I'm not that specific.
