Data Validation Source with 2 Substitutions

[thewiseguy]

Hi all,

I curently am using the following formula in my data validation:

=INDIRECT(SUBSTITUTE(U4," ","_"))

Is it possible to add another string to this:

=INDIRECT(SUBSTITUTE(U4,"&","and"))


Any help is greatly appreciated!!

 

[SunnyAlv]

Like this ?

=INDIRECT(SUBSTITUTE(SUBSTITUTE(U4,"&","and")," ","_"))

 

[thewiseguy]

thank you!