Splitting a cell data from excel into different variables

As the title suggests, i’m trying to get the program to split us the cell data in my excel sheet for 3 different dropdown menus on my site

How do I accomplish it without splitting up the data?

If it date hour format u can try something like this

CDate(varaible).ToString(“HH”) => HOUR

CDate(varaible).ToString(“MM”) => Minute

In addition to Nived:
to get the minutes you have to use the “m” format specifier.
CDate(varaible).ToString(“mm”) => Minute

Ref: Custom date and time format strings | Microsoft Docs

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