Hi, in excel, which I've included, I have a formula to pick out the alphabet, numbers or sprcial characters from a string.
and the reusult is determined by switch looking to a drop down list,
I have tried to create this so ;
![]()
Please Login or Register to view this content.
but the last part following the in I do not want hard coded I have created a paramer of the options, but this does not work when plugged into
text.combine, I have attached all this. I think the problem is that it sees the value from the parameter as "text", not referring to the variable,
I have tried putting it withing the let so simplified ;
but this does not work either? help?![]()
Please Login or Register to view this content.
Richard.
Bookmarks