Space between two texts

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.
 
you could also use a drop-down validation so a user has to choose the option
 
Back
Top