8 Aug 2013 at 09:25 #1 Conan257 Conan257 Associate Joined 8 Nov 2008 Posts 1,124 Location Lincoln I'm creating a spreadsheet but need some boxes to have spaces in the text. Ideally I'd like this to be an automated function. ie. Operator enters: abcdefghi Cell displays: abc def ghi Any ideas?
I'm creating a spreadsheet but need some boxes to have spaces in the text. Ideally I'd like this to be an automated function. ie. Operator enters: abcdefghi Cell displays: abc def ghi Any ideas?
8 Aug 2013 at 10:27 #3 Conan257 Conan257 Associate OP Joined 8 Nov 2008 Posts 1,124 Location Lincoln Yes, every entry will be 9 letter long, and I want to add a space between 3+4 and 6+7 so it appears as above...
Yes, every entry will be 9 letter long, and I want to add a space between 3+4 and 6+7 so it appears as above...
8 Aug 2013 at 10:29 #4 Conan257 Conan257 Associate OP Joined 8 Nov 2008 Posts 1,124 Location Lincoln I can do it with numbers easy enough.... ###_####_#### gives me the right formatting with numbers, I just can't do it with letters!
I can do it with numbers easy enough.... ###_####_#### gives me the right formatting with numbers, I just can't do it with letters!
