
I Have an Excel with Column Numbers
I need to pull this column in a dropdown and only fetch the number excluding "Tel : +"
Example : I should fetch only 123456788, 1223456789,123456790,.....so on
I am able to split one value using Split( dropdown1.SelectedText.Value , " +") , But not all
I want all Numbers values of table to be Split at a time and displayed in a dropdown ,
how do I use split function for this , if I use split function its expecting first parameter to be text , but for me its table
Split( Table1," +") is not working
how can I do this ?
Hi @Nida_Sayedi ,
Please try this:
AddColumns(LIST7,"temp",TrimEnds( Last(Split(Title,"+")).Value)).temp
Best Regards,
Wearsky