rit_netsys
New member
- Joined
- Jan 13, 2016
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi, I am having one excel sheet where on a column user should enter either "MAN INPUT" or "AUTO INPUT". Now I want to have a check on that. If by mistake, user enters 'MANINPUT" or "AUTOINPUT", it should automatically change to "MAN INPUT" or "AUTO INPUT". That means if user forgot to add space in between, excel should automatically add space in between. How to check and add space in between?? CONCATENATE will not help here I think. Any help will be appreciated.