Take data from 1 cell to create a new cell

K

kenetik

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?
 
B

Biff

Hi!

Try this:

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

Biff
 
B

Biff

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

Post the *EXACT* formula that you tried.

Biff
 
K

kenetik

=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.
 
B

Biff

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
 
Top