Take data from 1 cell to create a new cell

  • Thread starter Thread starter kenetik
  • Start date Start date
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?
 
Hi!

Try this:

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

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
 
=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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combining =SEARCH & =IF statements 4
How do I put cell data in between another cells data 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Average If... 12
Average Unique 7
using VLOOKUP to condense data on separate spreadsheet 3
how do i add commas in a single cell? 2
Paste Delimited 8

Back
Top