Macro to add prefix and increment?

I have a list of text in B2

is it possible to create a macro to add a prefix and an incremental value?

as an example, from this:

This is the first line of text
This is the second line of text
This is the third line of text
This is the fourth line of text

to this:

Prefix.001.00.This is the first line of text
Prefix.002.00.This is the second line of text
Prefix.003.00.This is the third line of text
Prefix.004.00.This is the fourth line of text

Thanks for any help


Jeff

Awesome!

Thank you very much


Jeff

UDF

C2
=AddPrefix(B2,"Prefix")

To a standard　module

Please Login or Register  to view this content.

Thanks Jindon!

Can this be converted to a macro?

Jeff

Is this what you mean?

Please Login or Register  to view this content.

Thanks Jindon!!