Extract data from a cell after a constant value

  • Thread starter Thread starter Wolfman
  • Start date Start date
W

Wolfman

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,

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
Click to expand...

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
 
Thanks Ron!


Ron Rosenfeld said:
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
Click to expand...
 
Back
Top