How can I separate 00584

[Kinetic_analytics]

Good morning.  

NAME:

00584 Ktech B225
00584 Ktech B225
00584 Ktech B225
00584 Ktech B225
00584 Ktech B225

Appreciate your help.

[JamesCharnley · Accepted solution]

@Kinetic_analytics 

If you just need to separate it then you don't even need RegEx here, text to columns will do.

[MilindG]

I have attached couple ways you can do that.

[BS_THE_ANALYST]

Hi, 

[ShankerV]

Hi @Kinetic_analytics 

One way of doing this!!!

Many thanks

Shanker V

[binu_acs]

@Kinetic_analytics One way of doing this with the string functions

[Kinetic_analytics]

@JamesCharnley  Thanks for your help this morning.

[Kinetic_analytics]

@MilindG Thanks for your help this morning.

[Kinetic_analytics]

@BS_THE_ANALYST Thanks for your help this morning.

[Kinetic_analytics]

@ShankerV Thanks for your help this morning.