Thread: Take data from 1 cell to create a new cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Take data from 1 cell to create a new 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?



Reply With QuoteReply With Quote