Special Character Issue

Help
1

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.

2

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

3

what condition and it goes like

4

@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
5

Hi,

U can also use regex to exclude any special characters.

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

6

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