insert asterisk in sequence

d2pren · May 2, 2017

I have a table like the TOP picture. In the second column I use the formula "NUMBER OF WORDS+1" >> =LEN(B11)-LEN(SUBSTITUTE(B11," ",""))+2

For the next column I want to insert ASTERIX in sequence like BOTTOM TABLE. What formulas/FUNCTIONs make it easy for me to do this task?

d2pren · May 2, 2017

SOLVED, thank you

Pecoflyer · May 2, 2017

Hello
perhaps you could share the solution with the board?

In the future please do not cross post without adding links ( read http://www.excelguru.ca/content.php?184 to understand why)

Thank you

AliGW · May 2, 2017

Asterix = comic character from Gaul

asterisk = symbol (*)

Pecoflyer · May 3, 2017

AliGW said:
Asterix = comic character from Gaul

asterisk = symbol (*)

:rolleyes2

insert asterisk in sequence

d2pren

New member

d2pren

New member

Pecoflyer

Admin Alumnus

AliGW

Administrator

Pecoflyer

Admin Alumnus