New Column

[racheljeska]

Hi all!

How do I create a formula to go from Column Example

Example

0934US923 Yellow Sun

03duiw839 Purple Flower

3648idahd Green Frog

To Column Example 1

Example 1

0934US923

03duiw839

3648idahd

I only want to keep the first 9 numbers/letters

[tackytechtom · Accepted solution]

Hi @racheljeska ,

Before:

After:

Below the steps that I used:

Let me know, if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/