SOLVED
column value split to different columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Keerthana_Adamana
6 - Meteoroid
‎07-15-2024
10:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I would like To split the column values like "MTW" into separate columns with individual values using the Text to Columns tool. Please do
Solved! Go to Solution.
Labels:
- Labels:
- Parse
3 REPLIES 3
binuacs
21 - Polaris
‎07-15-2024
11:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Keerthana_Adamana one way of doing this
‎07-15-2024
11:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs That was brilliant! It worked. If there is "MTh" i.e., Th should come in one column it should not split. Can you please solve this ?
binuacs
21 - Polaris
‎07-15-2024
02:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/A7612391DEAF4EF69C140133EA533832/responsive_peak/images/icon_anonymous_message.png)