extract

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

eg 20040506,

So i'm left with 2004.

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

eg 20040506,

So i'm left with 2004.

Thanks
David
Click to expand...

The Left function should do.

Left$("20040506", 4)
 

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

Excel Extract Text from decimal separated string 6
substring function 2
Extracting 7 digit number from alphanumeric string 10
Extract 5 digit number from a column 7
Extract number from text string based on number's format? 16
Extracting data from strings 9
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr 13
Linking 2 queries 3

Back
Top