Extract and rename cells

[bdavis407]

Hello all,
Yes....I'm a newbie to the forum. Many thanks to the many folks who donate time and resources to make this forum available to all.

Picture Rename Formula Quest.xlsx
Attached is a sample of what I need.

I have thousands of pictures to rename. Most are coded as shown in the attached file as ###E_ or ###F_ followed by a number with a .jpg file extension.

I want to drop the first group of numbers (always 5 places to the left) in the original file name and rename the cell according to the name placed in column B (Desired Name) using the number of the picture embedded in the original file name (five places from the left).

My problem is that the numbers are not in order and sometimes are in the 1000's, (4 spaces). The column is in general format.

I want to extract the number beginning in the sixth position and use it in the beginning of the new file name. Adding the ".jpg" is the easy part.

I'm convinced it's possible and I've played around with it long enough; so I'm putting it to the forum. Any recommendations are welcomed and appreciated. I suspect the answer and final formula is probably easier then I thought it would be.

Thanks all for your time and patience.

Bill - bdavis407

[djapigo]

Try this formula in D2... then copy to the rest...

=VALUE(MID(A2,SEARCH("_",A2)+1,SEARCH(".",A2)-SEARCH("_",A2)-1))&" "&B2&".jpg"

PS Thank you for such a clear question and example... if only your example is explained by others...

[ConneXionLost]

How about this:

Please Login or Register  to view this content.