GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Anybody good with Excel? I have a data validation question

96ukssob · 01-25-2007, 08:42 PM

not sure if this is what you mean, but if you put in the cell to the right of it

=len(**CELL**)

then to the right of that cell

=IF(**CELL WITH LEN FN**<55,**ORIGINAL CELL**," ")

then it will only display cells that have less than 55 characters

im goign to buy a new chair at staples, ill be on later if you need some help

edit: make sure to remove the **'s

01-25-2007, 08:42 PM
96ukssob So Fucking Banananananas Industry Role: Join Date: Mar 2003 Location: If I was in your ass you'd know it Posts: 12,991	not sure if this is what you mean, but if you put in the cell to the right of it =len(CELL) then to the right of that cell =IF(CELL WITH LEN FN<55,ORIGINAL CELL," ") then it will only display cells that have less than 55 characters im goign to buy a new chair at staples, ill be on later if you need some help edit: make sure to remove the **'s __________________ Email: Clicky on Me