Text to Columns

Hello:

I have a column with name, "Stage", and with Row values as follows

1 - New Meeting

2 - Old Meeting

3 - Not interested.

I wanted to convert these using text to columns with Numerals in one column, and String in another column. The way i got it working is using Text to columns twice, which i dont think is best practice, looking for any better suggestions

Best Practices

Accepted answers

One method would be to use RegEx (parse) instead with something like (\d+) - (.+) like the attached. Regex is great for data that has consistent structure like the " - " in your data set.

Regex.yxmd

All comments

bpatel

hi @rrevuru ,

did you use "-" as the delimiter and set number of columns to 2?

hope this helps!

rrevuru

Yes, i used - as a demiliter, but the problem is there is whitespace between delimiters.

One method would be to use RegEx (parse) instead with something like (\d+) - (.+) like the attached. Regex is great for data that has consistent structure like the " - " in your data set.

Regex.yxmd

meghak1590

You can use a formula tool and use a substring function Substring(String,Start,Length) to extract the part of a string Column.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335