Forum Discussion

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Your code worked for me.  The only change I made was to use "school1.com" instead of just "school1" in the Text.Contains, as school14 contains school1 for example.

 

Pat

 

  • massotebernoull's avatar
    massotebernoull
    Icon for Helper I rankHelper I
    4 years ago

    Sorry for not specifying it properly.

    I need that only null lines that have "@school1.com" in column USER change to "school1" in column SCHOOL.

    Other null values from other schools must continue as they are.

     

    Thanks for replying mahoneypat !