How to type phone number in Excle

 

Certainly! The LEN function in Excel calculates the length of a text string. It returns the number of characters in the given text, including spaces and punctuation. Here’s how to use it:

1. Syntax:

   • =LEN(text)
   • text: The text for which you want to calculate the length.

2. Examples:

   • =LEN("apple") returns 5.
   • =LEN("apple ") (with a space) returns 6.
   • =LEN(1000) (numeric value) returns 4.
   • =LEN("$1,000") (formatted number) also returns 4.

Remember that LEN counts characters in both text and numeric values, but number formatting is not included1.

Select on Column you want to set

Find word Conditional Formatting ðNew Rule 

Select User a formula to determine which cell to format  and then type formula =lan(select column) =8 or if you have 9 Number type 9 =lan(select column) =9

Click on Format ðCustom  Type 000 00 00 00

Result