Formula to calculate text or letter in cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 28 Feb 2007 11:42 GMT

Hi All

I've done this before, but cant remember how and I cant find anything
in help or on the internet.

I need a formula to calculate whether a specified cell has text
letters in it or numbers in it.

Does anyone have the answer?

Thanks

Adam

Reply to this Message

Roger Govier - 28 Feb 2007 12:14 GMT

Hi Adam

=ISNUMBER(A1)
=ISTEXT(A1)

will return TRUE or FALSE

Signature

Regards

Roger Govier

> Hi All
>
[quoted text clipped - 9 lines]
>
> Adam

Reply to this Message

Adam - 28 Feb 2007 19:37 GMT

On 28 Feb, 12:14, "Roger Govier" <r...@technologyNOSPAM4u.co.uk>
wrote:

> Hi Adam
>
[quoted text clipped - 20 lines]
>
> > Adam

Brilliant, thank you!

Reply to this Message

jan - 28 Feb 2007 12:18 GMT

Adam,

Perhaps this:

=ISNUMBER(A1)

Jan

> Hi All
>
[quoted text clipped - 9 lines]
>
> Adam

Reply to this Message

Rate this thread: