How can I do this?

Old Cell New
Cell
12345.pleasehelp.405503.245 pleasehelp.jpg
12345.differentname.405503.245 differentname.jpg

What formula would I put in new cell to create it from the data from
old cell?

Hi!

Try this:

=MID(A1,FIND(".",A1)+1,FIND(".",A1,FIND(".",A1)+1)-FIND(".",A1))&"jpg"

Biff

wrote in message
ups.com...
How can I do this?

Old Cell New
Cell
12345.pleasehelp.405503.245 pleasehelp.jpg
12345.differentname.405503.245 differentname.jpg

What formula would I put in new cell to create it from the data from
old cell?

Maybe I didnt do something right but it returned #NAME?

Maybe I didnt do something right but it returned #NAME?

The only way that it would return #NAME? is if you misspelled one of the
functions.

Post the *EXACT* formula that you tried.

Biff

wrote in message
oups.com...
Maybe I didnt do something right but it returned #NAME?

I copy and pasted exactly what you posted. =)

=MID(E2,FIND(".",E2)+1,FIND(".",E2,FIND(".",E2)+1)-FIND(".",E2))&"jpg"

That is exactly what I put in it.. E2 is where the original data is
found.

Ok, what's in E2?

If I use this sample that you posted and put it in E2:

12345.pleasehelp.405503.245

The formula retunrs this:

pleasehelp.jpg

Biff

wrote in message
ups.com...
=MID(E2,FIND(".",E2)+1,FIND(".",E2,FIND(".",E2)+1)-FIND(".",E2))&"jpg"

That is exactly what I put in it.. E2 is where the original data is
found.