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.
|