trim gets rid of all trailing spaces and leading spaces and double spaces from a text valu
e
so if you have text " bumholes " in cell A1 and you enter =trim(A1) in cell A2 you will get the result "bumholes"
i was wrong, it isn't LCase it's Lower (LCase is either Access/SQL or Business Objects i get very muddled between what to use in each, so thank f**k for intellitype)
Lower is similar to Trim in that it turns text of any case into lowercase, there's also Upper and Proper - Upper goes to uppercase and Proper puts a capital at the start of every word - good for names, but can't cope with us Irish e.g. O'leary or Mcgovern
Posted By: Ralf Scrampton on January 16th 2015 at 14:21:37
Message Thread
- PM YellerLee (General Chat) - Ralf Scrampton, Jan 16, 12:17:14
- Cheers. I worked it out myself in the end - the same as your first example (General Chat) - Yellalee, Jan 16, 12:24:04
- You know Said in OZ (General Chat) - pants, Jan 16, 12:20:07
- yeah, that still doesn't tally in my mind (General Chat) - Ralf Scrampton, Jan 16, 12:28:42
- I vividly remember him in it as well (spoilers if someone is considering watching it) (General Chat) - pants, Jan 16, 12:35:16
- me too, it isn't even like he looks dramatically different either (n/m) (General Chat) - Ralf Scrampton, Jan 16, 12:39:57
- I vividly remember him in it as well (spoilers if someone is considering watching it) (General Chat) - pants, Jan 16, 12:35:16
- yeah, that still doesn't tally in my mind (General Chat) - Ralf Scrampton, Jan 16, 12:28:42
- or more correctly: (General Chat) - Ralf Scrampton, Jan 16, 12:19:46
- How do trim and lcase work? Not used them before. (n/m) (General Chat) - megson, Jan 16, 12:48:21
- trim gets rid of all trailing spaces and leading spaces and double spaces from a text valu (General Chat) - Ralf Scrampton, Jan 16, 14:21:37
- ^^^ that ain't correct (General Chat) - Ralf Scrampton, Jan 16, 12:26:05
- Luckily I've added a validation list to choose from (General Chat) - Yellalee, Jan 16, 12:27:01
- good stuff :-) (General Chat) - Ralf Scrampton, Jan 16, 12:30:46
- Luckily I've added a validation list to choose from (General Chat) - Yellalee, Jan 16, 12:27:01
- How do trim and lcase work? Not used them before. (n/m) (General Chat) - megson, Jan 16, 12:48:21
Reply to Message
In order to add a post to the WotB Message Board you must be a registered WotB user.
If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.