 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007Extract data from a cell after a constant value
Howdy All, I have a spreadsheet that contains 1 column of data, if the cells of the column are the city names and populations of towns in the following format: Appleton, Wisconsin (WI) (pop. 70,087) The 'pop.' is always present. I want to extract just the population number (ie: 70,087) from these cells into another cell. What is the simplest way to accomplish this? Thank you, Brian >Howdy All, > [quoted text clipped - 11 lines] >Thank you, >Brian Extracts the value as text: =SUBSTITUTE(MID(A1,FIND("(pop.",A1)+5,255),")","") To turn it into a "number": =--SUBSTITUTE(MID(A1,FIND("(pop.",A1)+5,255),")","") --ron
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.