Forum Discussion

clh_1496's avatar
clh_1496
Brass Contributor
May 27, 2022
Solved

alternative to "" when using in Macros

Hi,   I have this formula, which contains multiple "" when looking to see if text is in the cell :  =IF(ISNUMBER(SEARCH("Sling",D6)),"Sling/Lab",IF(ISNUMBER(SEARCH("Dress",D6)),"Dressing",IF(ISNUM...
excel
Formulas and Functions
Macros and VBA
  • NikolinoDE's avatar
    NikolinoDE
    May 27, 2022
    ""Sling""
    ""Dress"" ...etc.
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
May 27, 2022
""Sling""
""Dress"" ...etc.
clh_1496's avatar
clh_1496
Brass Contributor
May 30, 2022
ah perfect, I tried the double "" in the formula in excel but have realised it only works in the formula in the VBA

Resources