Split variable in Excel

Help
1

Dear friends
I want split the variable 10/15/2018/ 00:00:00 in one Excel cell,but I only want select the 15 to use
what activity I can use to solve it
Thank your for your help.

2

@Chenzhixing.PRC Use below command it will be useful. After getting value from excel convert it to string datatype and then use below thing.

Split(UrStringVariable,“/”)(1)

3

Hello,

Use substring() method to get only 15 from string.
str1.Substring(3,2)

Cheers,
Pankaj

4

thank you for your help
solve it !!!

1 Like
5

@Chenzhixing.PRC if you found the solution close the thread by marking solution.