Thread: formula for pulling only numbers but not text from another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKphidelt AKphidelt is offline
external usenet poster
  
Posts: 461
Default formula for pulling only numbers but not text from another cell
In cell B2 type

=LEFT(A2,LEN(A2)-FIND(" ",A2,1))

In Cell B3 type

=RIGHT(A2,LEN(A2)-FIND(" ",A2,1))

"Jamie" wrote:

I need a formula to pull only numbers and one to pull oinly letters from a
cell and put them in another cell.
Scenario:
Worksheet A, Cell A2= (7) apples
I want: Worksheet B, Cell B2 to = (7)
Worksheet B, Cell B3 to = apples
Reply With QuoteReply With Quote