Split Text to Column - Get First 5 digits

Hi,

I would like to split the data in column ‘Text’ by using comma and get only the first 5 number of the text. Can anyone help me on this. Your help will be much appreciated.

Before:
image

After:
image
Test.xlsx (13.7 KB)

Hi,

Hope the following helps you.

Sample20210330-1.zip (22.5 KB)

Regards,

1 Like

Thank you so much for your fast response. I got what I needed.

1 Like

Hi @jenkim
I see the topic is already resolved, I solved it as well so sharing just in case.Main.xaml (12.8 KB)

Last assign is: arr_Text(0).ToString.Substring(0,5)

1 Like

Thank you so much for your help. I’m able to learn more about this. :smiley:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.