I am trying to create a condition so that if the first character in a cell is not a number, then delete the entire row
can't figure out what to insert where the * isPlease Login or Register to view this content.
Thanks
I am trying to create a condition so that if the first character in a cell is not a number, then delete the entire row
can't figure out what to insert where the * isPlease Login or Register to view this content.
Thanks
Use IsNumeric like this
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you - very helpful
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks