adding prefix numbers to text in column automatically?

Hello everyone,

I'm new the boards, and just started a new job that requires a lot of macros.

My first question is,

Column A has a goes from 1-950 in each row respectively.

For instance,

Row 1 under column A = 0
Row 2 under column A = 1
and so on...

I want to add "00000" to the front of each number and ".jpg" to the back of each number.

Final Result

Row 1 under column A = 000000.jpg
Row 2 under column A = 000001.jpg
and so on...

If anyone knows of a easy approach to do this instead of manually doing through each row, let me know!

I appreciate it greatly

-JEsse

Thank you sir.

That helped, but it replaced with the data I already had.

For example, I have some names on there.

James
Jesse
Brian
Janet
Peggy

I want the code to input the "00000" and the ".jpg" and keep the data that is already there.

So...

00000James.jpg
00000Jesse.jpg
00000Brian.jpg

and so on...

Any ideas for that?

Thank you again,
-Jesse

Welcome to the forum.

Please read our Forum Rules about thread titles, and then edit yours to be descriptive of your problem.

What was your original question then ?

Please Login or Register  to view this content.