Extraction from a cell

  • Thread starter Thread starter Sal Iaccarino
  • Start date Start date
S

Sal Iaccarino

I have the following in a cell: 2486 Orchid Bay Dr, X102

I would like to keep this cell as it is, however, I would like to extract
the X102 into another cell by itself.

Can someone indicate a formula to do this?

Thanks Sal and Eileen
 
Sal,

Assuming that there is always a comma as shown in your example,
the following formula will return the text following the comma.

=MID(A1,FIND(",",A1)+2,LEN(A1))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi

Try this:
=MID(A2,FIND(",",A2)+2,256)
It finds the comma and returns the data from beyound the space after it.
 

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

Formulaneeded for extraction 6
Extract data from a cell 4
IF function says too many nested 1
Extracting text from a cell 3
a cell contain formula, how to extract value of that cell 1
extracting data from a cell 2
How to extract separated text by many commas in Excel? 0
Extracting Data from a string of text in a cell 4

Back
Top