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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find a word in a table, then use a function 3
use of wildcards in conditional formatting 5
Splitting a number in one cell into other cells 0
Highlighting multiple triggers 4
Sort Columns of data at the same time, without regard to order. 3
Matching column criteria in a one to many relationship 8
Holiday and sick leave records 1
Splitting information in cells 7

Top