Search results

I'm able to use "concatenate" to combine and "len" to do the count, but is there a way to concatenate adding the spaces based on the value found through "len"? Thanks in advance- Jon.

The number of characters will never >22, but will always be less. I'm going to research further into what you posted and will post back up if I have any questions. Thanks- Jon

Sorry, I'm a real newbie. I've learned so much from reading on this forum. I have 4 fields I'm trying to combine, but I need to add spaces between field 1 and the rest of them. The total character count needs to be 22 including the spaces. Example: Field 1: THE Field 2: 1234 Field 3: BOAT...