How do I indicate a cell that doesnt contain an actual telephone number

[john dalton]

Hi i am putting together a sheet that uses exported information from another software package, the information contains a column of telehpone numbers, some cells in the column appear to be blank, however when I use =code to signify an occupied cell (either 48 or 32), this helps however I want to use a helper column to either indcvate a 1 for an actual telephone number or a 2 for what appears to be a blank cell.

Due to the sensitive nature of the number I cannot post an example.

Any ideas welcome.

John

[Roger Govier]

Hi John

You could use
=IF(ISBLANK(A1),2,1)

Alternatively, if your data is in a Table, or if you apply Autofilter to your list, you could use the dropdown on the relevant column > De-Select All > Select Blank

[john dalton]

Hi Roger, thanks for the response, I have applied your formula but it still returns a 1 on a cell that appears blank but isnt.

John

[Roger Govier]

Hi John

then the "blank" cell has a space character or some hidden character.
On the assumption it is likely to be a single space, then try the following
=IF(ISBLANK(A1),2,IF(LEN(A1)=1,3,1))

[john dalton]

Brilliant mate, works a treat.

JD