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

Search results

  1. B

    Removing an extra space within a string

    Here is the data I am trying to clean. Income Expense Staff Salary 0 83 869 Money Transfer 350 000 0 Repair work 0 21 361 Electricity 0 11 360 Water 0 4 544 I need to convert 350 000 to $350,000, 83 869 to $83,869, etc If I...
  2. B

    Removing an extra space within a string

    I am importing raw data from an on line game I play; I import a string format that I need to convert to a number (currency). for example: 203 101 is the string that gets imported I tried doing the find " " and replace with "" first but that does not work. I have been clicking inside the text...
  3. B

    Mouse Settings

    I have a rather large list of items I want to timestamp. I have a column with all cells values at =now(). Is there a way I can "program" my mouse key to copy the cell and paste as a value with one click instead of having to copy then select "paste special values" then CHOSE "select special...
  4. B

    Need Help With Pareto Chart

    ok, thank you! Sometimes the obvious eludes me :)
  5. B

    Need Help With Pareto Chart

    I have built a Pareto Chart with a dual axis. My Pareto line is based on the accumalative % and looks similar to the one I saw in Wikipedia and on the Pareto Chart template this website offers. Sadly, my boss wants the Pareto line to start at the top of the bar of my first data element. I would...
Back
Top