View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
 
Posts: 340
Default How can i split combined number and text in excel using formul

I think you need to enter LITERS in CAPS. Alternatively use UPPER(!A1)
instead of !A1.

romelsb wrote:

Lori--i tried it the results remains with 20 + 50 liters , i miss the 70
liters result...pls. retry your help....thanks.

--
"Bright minds are blessed to those who share them.."-rsb.