Special Character Issue

does anyone know How to Get Special character In Excel

for example in excel A1
I have text “THE QUICK BROWN-FOX *JUMP &OVER THE LAZY DOG”

then i want to display special character in message box “invalid it has special character of -#&
if no special character then proceed to A2 A3 A4 …until it has or no Text to check

and it has valid special character like a ,( ){ }
if not valid Display "invalid it has special character of “typesofspecialcharacter

thank you in advance.

@adwas111 Use if condition and check if it contains ** -#&** display message box

what condition and it goes like

@adwas111

  • Use get row item activity and pass column name assume v1

  • use if condition to check as shown below

                       if(v1.Contains("-#&"))
                     {
                            Display message box
                      }
1 Like

Hi,

U can also use regex to exclude any special characters.

[^0-9a-zA-Z]*

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