Nov
22
Microsoft Excel — Does anyone know if or how to create a formula to read only certain text behind a comma?
Filed Under (Software) by
Huntsville
Matthew G asked:


Example: If I have a cell that will contain Huntsville, AL — Is it possible to create a formula that can read only the text behind the comma which would be , AL — Based on the formula identifying AL then we can have the formula perform a particular function?

QUEAL
Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • blinkbits
  • BlinkList
  • De.lirio.us
  • Fark
  • Faves
  • Fleck
  • Furl
  • LinkedIn
  • Live
  • Ma.gnolia
  • MySpace
  • Propeller
  • description
  • Simpy
  • Spurl
  • StumbleUpon
  • Technorati
  • ThisNext
  • TwitThis
  • Yahoo! Buzz
  • YahooMyWeb
  • Yigg

Comments

AQuestionMark on 24 November, 2009 at 2:53 am #

Huntsville locate the full form in the above on a1 use it to adjust for the in a1 to extract the space before al mid function use it to the line huntsville al is 11 in vlookup eg table list all states short.