markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello
Basically, I have column and I want people to enter letters with a comma after each letter so they might enter ABC they would be forced to enter it as A,B,C or CDEF forced to enter as C,D,E,F
I looked at data validation but can't see an option to do something like this. I'm sure there must be - any ideas?
Thanks,
Mark
Basically, I have column and I want people to enter letters with a comma after each letter so they might enter ABC they would be forced to enter it as A,B,C or CDEF forced to enter as C,D,E,F
I looked at data validation but can't see an option to do something like this. I'm sure there must be - any ideas?
Thanks,
Mark