Splitting a Cell into Var's

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
 
S

steve smallman

Hi,

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

Steve
 
Top