• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

replace text with blanks

Are these numbers in the same cell or in the different cells.

For eg Cell A1 = 20 nos Cell B2 = 30 nos etc. Do you want them ??
You can use Right Function and separate them.

Or

If the text is common then replace it with the text and Blank using Ctrl+F
 
Use Ctrl+H and in Find What enter nos and in Replace With Dont Enter anythin. It will retain only the numbers and in the same way do it for PKT. At the end SUM all.
 
hi,
I dont want to use ctrl+f or ctrl+h i want do with formulas
i heard with solve with using * or any option
i gave examples only that nos, pkts but i meant text along with number in that i want only numbers out
sorry for unclear earlier
 
dear bharath,
if your alphanumerical text is in A1 then put the below formula in B1 and hit ctrl+shift+enter
=MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$9),1)),0),COUNT(1*MID(A1,ROW($1:$9),1)))
inform whether the solution help you or not.
 
You must log in or register to reply here.
Back
Top