View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Take data from 1 cell to create a new cell

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?