If statement

[jrabi]

I have a spreasheet in column B I have a market name example 333 St Lukes, and also in column B I have sales figures. I want a formula in column A that will give me just the market names such as below:

Column A Column B
333 St Lukes 333 St lukes
25
30
40
221 becon 221 becon


Is there a way to do this.

 

[jrabi]

Sorry that example did not post correctly, below is the example, so in col A I only want the formula to return the name or text........

Column AColumn B333 St Lukes333 St Lukes 25 30 22 21212 Becon212 Becon

 

[jrabi]

Column AColumn B333 St Lukes333 St Lukes 25 30 22 21212 Becon212 Becon

Lets try again

 

[jrabi]

Ok, not sure how to post an excel spreadsheet example, sorry.....

 

[Scott Huish]

That sample's hard to follow but do you just want to display in Column B what is in Column A if it is not just a number?

=IF(ISNUMBER(A1),"",A1)

Copy down.

 

[jrabi]

Works perfectly, thanks and sorry for the crappy post, in a rush here,,,,

 

[Michael M]

Hi Jrabi
For future reference, if you need to post a sample of your data, read the 2nd line of my post and download the HTML Maker or
highlight a SMALL sample of your data and then place a border around that selection....then simply copy and paste the selection.

HTH