I need to set up some columns for CSV export and they require a specific length that must be filled with blank spaces if the cell content is smaller in length.
On Google Sheets this works very nicely with
=B2&REPT(" ",35-LEN(B2))
On AppSheet this is the only way that I have figured out so far:
SWITCH(LEN[Name],
1, [Name]&" ",
2, [Name]&" ",
3, [Name]&" ",
4, [Name]&" ",
5, [Name]&" ",
6, [Name]&" ",
7, [Name]&" ",
8, [Name]&" ",
9, [Name]&" ",
[Name]
)
Thanks in advanced!
Solved! Go to Solution.
How about using Left().
Left-most characters of text |
Something like this:
left([Name] & " ", 35)
How about using Left().
Left-most characters of text |
Something like this:
left([Name] & " ", 35)
👏👏👏
Yep, that definitely works and is much cleaner than what I had come up with...
Thanks!
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |