How to un concatenate data

I have the following information in one column: St900Wk5Day41273
I need to have 6 separate columns: St  900 Wk 5 Day 41273
I can't select the column and use the Text to Columns option b/c some of the store numbers have 4 digits, for example: St1326Wk8Day41298
so it'll have to be St 1326 Wk 8 Day 41298...Is there a formula that can separate it correctly?
Thanks!
LadkissonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
nutschConnect With a Mentor Commented:
Formulas from left to right for your six columns (assuming only the store number shifts from 3-4 characters)

St
=--mid(a1,3,find("Wk",a1)-3)
Wk
=--mid(a1,find("Wk",a1)+2,find("Day",a1)-find("Wk",a1)-2)
Day
=--mid(a1,find("Day",a1)+3,len(a1))
0
 
LadkissonAuthor Commented:
Wonderful! Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.