Hi all,
I wanna stop user from entering space before or after text in data validation
Dan
Hi all,
I wanna stop user from entering space before or after text in data validation
Dan
Last edited by dan66656; 05-07-2015 at 07:18 AM.
Hi there. try this in the DV
=NOT(OR(LEFT(A1,1)=" ", RIGHT(A1,1)=" "))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Dan,
Adding to Glenn's formula
You can use TRIM function also
Settings> Custom>FormulaFormula:Please Login or Register to view this content.
Regards,
AM
@ Glenn: Thanks for the rep
@Dan: If you got the resolution then please mark the thread as SOLVED.
Also click on Add rep who has helped you.
Regards,
AM
Thanks Glenn & AM
Dan
thanks Dan for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks