Superscript

[James Perry]

Hello friends:

Worksheet #1 contains lots of first-names. Really can't tell ya the number of it all.
For instance, the name 'Amanda' may appear a number of times in different cells in the worksheet. Ditto for 'Belinda', Candice, Samantha, & James.
Each name may appear 20 times, 50 times, 99 times,….the list goes on.
I am looking for a solution with the help of a 'superscript'.
For instance I would like the name 'Amanda' to appear in the worksheet as Amanda20. But the number 20 must appear as a superscript.

Thank you. Much appreciated.

 

[BBD]

Hi James,
Attached is a file which you can use to superscript as required.
Cheers,
BD

 

[BBD]

Missed the file

 

[SirJB7]

@BBD
Hi!
In your uploaded file there's a last extra zero in every superscript. Shouldn't you replace this:
Length:=Len(Range("f1")) - i + 1
by this:
Length:=Len(cell) - i + 1
in the procedure test at module Module1?
Regards!

 

[BBD]

@SirJB7

Nice catch Was testing the data with F1 and missed out changing it.

Thank you !!

@James Perry
Use the file below.

 

[SirJB7]

@BBD
Hi!
You can also replace this:
Range(cell.address)
by this:
cell
since the same object (cell range) is referenced as the object related to an object address.
Regards!

 

[BBD]

@SirJB7

Nice one !! Thank you

 

[James Perry]

@BBD: Thank you very much. That was simply awesome…..and gave me new perspective.
Stay blessed.

 

[James Perry]

@SirJB7: Thank u for your input & blessings.

 

[SirJB7]

Hi, James Perry!
Glad you solved it. All credit to BBD who did the dirty job. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
Regards!