Is there a custom word filler and threshold code?

[Fucius]

Is there a way to mass fill columns with various word lengths with custom character and character length threshold?

I want to use custom with asterik to fill up to 10 characters including the original word, and if the word goes over 10 characters to limit it to 10 only.

For Example:

BEFORE:

RUN
TURNUPTHEBASS
JOEBLOW

AFTER:

RUN*******
TURNUPTHEB
JOEBLOW***

Thanks in advance!

 

[shg]

In a convenient column, =LEFT(A1,10) & REPT("*", MAX(10 - LEN(A1), 0))

 

[Fucius]

shg - YOU ARE DAH MAN! The code works like a charm, thanks so much!!

 

[mikerickson]

A different formula
=LEFT(A1&"**********", 10)

 

[Fucius]

mikerickson - NICE, Your code is simple & clean! Thanks so much!