Solved

# How to un concatenate data

Posted on 2013-02-06
833 Views
Last Modified: 2013-02-06
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!
0
Question by:Ladkisson
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
2 Comments

LVL 39

Accepted Solution

nutsch earned 350 total points
ID: 38860396
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

Author Closing Comment

ID: 38860457
Wonderful! Thank you!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
###### Suggested Courses
Course of the Month8 days, 4 hours left to enroll

#### 737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.