Formula for extracting the first 6 digits of the cell?

[SkiliedSin]

Hello, I am looking for some help on a formula that would give me the first 6 numbers of a cell from left to right. The difficulty is that the cells have varying amounts of letters before the first digit. Thanks!

 

[jtakw]

Hi,

Would help us help you if you post a few samples of your data.

 

[SkiliedSin]

Whoops, sorry about that.

For example, a few of the cells are xxxxx052012 while others are xxxxxx062012. I am just looking to get the first 6 numbers of the cell.

 

[hotabae]

This is a super messy way to search A1:

=LEFT(RIGHT(A1,LEN(A1)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+1),6)

It finds where the first digit(0-9) is hiding, and then stores everything from that point onwards.

Next, it eliminates everything after the first 6 chars.

Note: it only works if your format is like you said (no letters between the numbers and stuff like that)

Edit: Original was via copy/paste, but upon further review this is a cleaner version of the formula:

=MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),6)

 

[SkiliedSin]

Thank you so much!