Cameron Stewart

Posts: n/a

Function / formula to be used if cell contains a letter.

I have a colum of values that includes data such as this:

1.9825
1.8770a
1.4617
1.02x20
1.4061
1.4163c
1.8002
2.4261
2.9756
3.6d679
1.6860

I want an if statement that says - if cell value contains ANY LETTER then . . . .

(NB - the letter may be in any position in the number sequence.)

Any Help?

Cameron

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula HELP	Jay	Excel Worksheet Functions	3	October 14th 05 05:13 AM
Display answer only in another cell of one containing a formula	Mally	Excel Discussion (Misc queries)	5	January 21st 05 01:07 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell	[email protected]	New Users to Excel	2	January 6th 05 07:18 AM
Cell contents vs. Formula contents	Sarah	Excel Discussion (Misc queries)	3	December 15th 04 06:02 PM
copy a cell value not its function	KC Mao	Excel Discussion (Misc queries)	2	December 4th 04 04:30 AM

All times are GMT +1. The time now is 10:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us