Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 07, 2023 08:50 AM
Hi everybody, I'm trying to come up with a formula that would add after some text (taken from another field) the number of spaces needed to reach a total number of character.
Let's say I have to get to 10 total character, starting from the text from a field name "Text".
If text is "ab" I would need the formula to add 8 spaces after "ab" in order to reach 10 total characters
If text is "abc" the formula should add 7 spaces after "abc" to reach 10 total characters, and so on.
Is this possible?
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2023 06:21 AM
Yeap it is
And the formula used:
Name & REPT( " ", 10 - LEN(Name) )
