Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
wildcards in excel
Name: rinsitah Date: July 13, 2005 at 14:18:14 Pacific OS: win2k sp4 CPU/Ram: athlon xp 2400 / 512 meg
Comment:
I am wondering if it is possible to do this:
if a cells 1st character is a letter then do something, and if it is a number, do something else.
Name: StuartS Date: July 13, 2005 at 15:03:06 Pacific
Reply:
This will check is the contents of a cell is numeric or text.
=IF(ISNUMBER(A1),"Is Number","Not Number")
However it will evalute the whole cell. You can use LEFT(A1,1) but that only works on text fields. You may have to use a combination of formulas to to first convert a numeric field to text.
Summary: How can I create a print button in excel so that the user by clicking it will get the whole document printed? BUT The page must not have any background colour on it, nor should the links being seen. O...
Summary: I need to Sort an entire row by date automatically (close of escrow). I would like to be able to hit a button and the sheet sorts all the rows by date. I am making a spreadsheet that keeps track of Mo...
0 
