LinkBack URL
About LinkBacks
Hi all,
Can someone please help me how can I use formula in data validation in such a way that user can not enter leading space in front of the text.
I need an error alert pop up kind of notification.
Regards,
Vikas
Hi all,
Can someone please help me how can I use formula in data validation in such a way that user can not enter leading space in front of the text.
I need an error alert pop up kind of notification.
Regards,
Vikas
You could use this as the DV formula:
=NOT(LEFT(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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks