Splitting a Cell into Var's

  • Thread starter Thread starter sh0t2bts
  • Start date Start date
S

sh0t2bts

Hi

I have a cell that hold staff shift number EG S1, S2 , S3 etc

when they are sick of on holidays it would be imputted as S1S, S2H etc etc

I only want the first 2 char's so I can work out there shift patten and thus
know when I need somone to cover them.

I can do this and put the values into two diffrent cells but it would be
cleaner if I could do this in VBA.


Many Thanks

Mark
 
Hi,

try =left(a1,2), this will return the two leftmost
characters in cell A1

Steve
 
Back
Top