Get instant live expert help on how to remove formula in excel and keep values

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi I want to remove 0 in fornt of a number. I have an Excel Sheet that has 10020 values Inside. And most of the Values in 02899988989S. So How to remove the Zero in Front Of them.
Solved by G. H. in 17 mins
Hi team i have value in one cell more then one how to keep only one value and remove duplicate value like 7051387239,7051387239,7051387239,7051387239,7051387239,7051387239,7051387239,7051387239
Solved by G. E. in 22 mins
How to get unique values in a column without using remove duplicates?
Solved by S. W. in 19 mins
remove gray area but keep forumlas in tack.
Solved by B. U. in 20 mins
i need to remove duplicate value and to keep new entry
Solved by X. J. in 30 mins