Comments on: How to replace formulas with their values in Excel

Here are good tips to save your time - 2 fastest ways to replace formulas in Excel cells with their values. Both hints work for Excel 2019, 2016 - 2003. Continue reading →

Comments page 2. Total comments: 55

  1. Couldn't leave without thanking you for good job and advice. Thank you

  2. I admire the useful info you provide in your content. I&#;l1782l bookmark your weblog and have my children check up here usually. I am very positive they will learn a lot of new things right here than anyone else!

  3. THANK YOU! Exactly what I needed! :)

  4. i had made a sheet called projection with the help of value from different excel file.but while opening that file after some hours in place of value #ref appear how can i resolve it

  5. HOW TO ADD MORE THAN 16 DIGIT NUMBERS IN EXCEL

  6. Is there any way to convert conditioning value to original valve?
    please any assist?

    Thanks in advance.

  7. HI there
    I have a sheet with raw data. A second sheet with a conversion table. How do I convert the raw data to the converted values, using the conversion table as a ref?

    1. The shortcoming of this built-in solution is that, it doesn't allow to edit multiple cells at a time.

  9. THANK YOU!!!

  10. Thanks ! U r great. :)

  11. I installed but not showing up anywhere.
    I 've looked in add-ins and all customizeable menus - and can't seem to figure out how to get it to show up on my menus.

  12. please send excel send me excel file for numbers covert to words im try so many times but not get formula please send me file

  13. please send me excel file numbers covert to words in dollars im try so many times but not i am not get that formuala please send excel file

  14. Thanx for helping me..thats very useful to me

  15. how to combine 10-15 files of excel into one file............ please tell e the easy way for that.

  16. Formula to value - does what it says on the tin - bang on - cheers

    1. I want 12 to be added if X is greater than 2 and leave X as it is if Xmas is less than 2

  17. I'll add that I am not looking for the "paste values" solution. Basically, I need to set up a function/formula that automatically pastes the values over to a new column without the formula formatting. Just text.

  18. Can anyone help me!?! I have a column with data that is the result of a formula. So, I'd like to create another column next to it that has the exact same data, but just as text values, not as the product of the formula. So, when new values are created on the formula side, the second column is automatically populated with resulting values BUT IN TEXT FORMAT ONLY. The problem I am having is that when my original column of data is populated from the result of the formula, the cells that I would like to be blank are not blank, they are shown as zero. If I can get the information to automatically populate a column of text values only, I can set up conditional formatting that will remove any zeros, which will make my life a lot easier. I appreciate it.

    1. It is possible to do only with VBA.
      Under--Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      It will be populated in the corresponding column, by placing IF clause. Now you need only value. So convert it into to special paste value from vba script. At last loop will close and selection change process will be deactivated once you click/change value.

      Hope It will help you.

    2. You can't really have a cell automatically populating based on another cell without a formula. If there's no formula, it will be static.

      If you're looking for the 2nd column to be the same as the first but without the 0 values try using =if(A1=0,"",A1) in the 2nd column, or something like that. (This sets the 2nd column value to Null/Empty instead of a zero)

  19. Thank you!!! Exactly what i was looking for. Fastest method founded. Thanks.

  20. fRANKLY, IT WAS EXACTLY WHAT I WAS LOOKING FOR.
    THANKS A LOT

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)