Split Text to 2 Columns with repeated delimiter

[Adityasa]

Hi,

I have a column that looks like this below:

XYZ - Mumbai - Apple

ABC - Delhi - Ball

DEF - Kolkata

GHI - Chennai

And I want to split the above column into two columns:

[Column 1]   [Column 2]

XYZ              Mumbai - Apple

ABC              Delhi - Ball

DEF              Kolkata

GHI               Chennai

So I want to use only the first dash as the delimiter. Can someone please guide me?

Thanks.

[mpennington · Accepted solution]

You just need a RegEx Parse:

(.+?)\s-\s(.*)

[AngelosPachis · Accepted solution]

Hi @Adityasa ,

Besides the method provided by @mpennington , you can also use a text to columns tool which is slightly easier to configure if you are not familiar with RegEx. You just have to define the delimiter and then the number of columns you are looking to create.

Cheers,

Angelos