0
I have a list of strings (names / description text) that I need to add 'filler' characters to.
The maximum string length is 32 - for any text under that (in characters) I need to add special filler characters - up to that limit.
EG:
Original String - 30char - ReallyLong String Name Example
Revised String - 32char - ReallyLong String Name Example**
What is the best way to do this either with excel / sheets on it's own OR with a formula?
Thank you for your time!
2Nice one @Brian, to make it even tidier:
=LEFT(A1&REPT("*",32),32)
, you can leave outCONCAT
as it serves no purpose in here, plus it's a function only available from office 365 insiders and office 2019 if I'm not mistaken. :) – JvdV – 2019-07-15T20:08:21.6631@JvdV Cool
Rept()
function JvdV. Then I can satisfy my OCD with=IF(LEN(A1)<32,A1&REPT("*",32-LEN(A1)),A1)
Did not realizeconcat()
might be limited. Hopefully at least the fully spelled outconcatenate()
is available to all users. – Brian – 2019-07-15T20:49:51.013It certainly is available, but why a check for Len? It's irrelevant – JvdV – 2019-07-15T20:57:20.373