extract

B

bradasley

How can I extract the 1st 4 digits from a string,

eg 20040506,

So i'm left with 2004.

Thanks
David
 
R

RoyVidar

bradasley said:
How can I extract the 1st 4 digits from a string,

eg 20040506,

So i'm left with 2004.

Thanks
David

The Left function should do.

Left$("20040506", 4)
 
Top