separating the value

  • Thread starter Thread starter navin
  • Start date Start date
N

navin

Hi,

In one cell I have name in this format XXX - XXX - PHOENIX, XX. My
requirement is that the out should show PHOENIX.

Please help.

Thanks
Navin
 
=MID(A1,13,FIND(",",A1)-13)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
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

concatenate entries from a column into a cell by logical AND withanother column 2
Macro to extract few values from a cell 3
Nested IF Conditions 6
Sorting does not distinguish between Œ and OE or Æ and AE 1
Extracting data after SECOND dash 1
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
Conversion of 10 digit number into xx-xxx-xx-xxx 4
Extract Phone Number Forumula 7

Back
Top