Share via

Cell formation

Anonymous
2024-10-07T05:56:38+00:00

=AND(ISNUMBER(SEARCH("@",C5)), ISNUMBER(SEARCH(".",C5))) --Warn me to bad format in cell

=ISTEXT(A1) restricts the filling

Didnt work. why?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-08T03:17:03+00:00

    Hi Mészáros János1,

    Thanks for your post in Microsoft Community.

    First formula: It appears that you are trying to detect whether a cell contains both the "@" and "." characters, and this formula looks correct.

    Second formula: The ISTEXT function is used to determine whether the value in a cell is of type TEXT. If you want to restrict a cell so that it only accepts text input, you might consider using the Data Validation feature. 

    For example, I restricted input to only 1-2 characters of text. 

    When I attempt to enter more than two characters, the input cannot be completed.

    Please share more context and a screenshot of the complete worksheet so that I can better understand your issue, and I look forward to your reply!

    Best Regards,

    Thomas C - MSFT | Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments