Posted to microsoft.public.excel.programming

Steph[_3_] Steph[_3_] is offline

external usenet poster

Posts: 312

Dataval question

I use the below formula in datavalidation to not allow commas in the cell.
Is there a way to add to this to also not allow more than 1 blank space in
the cell? Thank you!!

=IF(ISERROR(FIND(",",B5)),1,0)

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
Question on looking up data	Nick H[_2_]	Excel Worksheet Functions	2	June 5th 09 03:34 PM
Data Table Question?	Bob	Excel Discussion (Misc queries)	2	June 3rd 09 02:09 AM
Data Filtering question.	KUKA Guy	Excel Worksheet Functions	9	March 9th 07 11:33 AM
VBA Question / Clearing out All Data	carl	Excel Worksheet Functions	3	March 2nd 05 07:57 PM
Data Validation Question	Kenny	Excel Programming	2	November 11th 03 05:28 AM

All times are GMT +1. The time now is 11:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us