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

    WEB Grabs Data Extraction from the net with Macros

    Hi, Just wondering if any one done this before, i am not good with macros or vb, but was thinking if could have a general sheet with a macro that could grab the data from a given URL. Have seen another Topic...
  2. N

    FLIP or Interchange or Swap words in any language

    Hi can any one help on the following (right to left - Arabic), but would prefer a general formula for any language type. Original Text المسلسل التاريخي - أسعد الوراق Final Result المسلسل التاريخي - أسعد الوراق The above has to be true for any case, if we have 2 words, 3 words, 4...
  3. N

    Extracting data in a given Tabular Format to a new sheet (Time,Date,Text,etc...)

    Hi Can someone help on the extraction of data from the first sheet in the format provided in the sheet. Link for the file. https://docs.google.com/open?id=0B5jCQSsK1WJ9VVFYeDM2U2hUaTZNYzhDdHRZLThPQQ Appreciated. NJ
  4. N

    Add or Subtract Time

    Hi I was looking for some help on calculating time based on a column of time provided. How values are displayed is shown below. Original Time format...............Subtract 4 Hours...............Subtract 9 Hours...............Add 2 Hours...............Add 9 Hours...
  5. N

    Selecting Rows based on empty values on the left

    Hi There File uploaded here, https://docs.google.com/open?id=0B5jCQSsK1WJ9RHJmMkJrMTVTSE81c1pGY0tqN3Uydw Any can help on the issue as i want the data from these rows to be transferred to another sheet and look like the one attached below...
  6. N

    Set Chart Series Colors to Match Source Cell Colors Based on Conditional Format

    Hi There I Have a series of data either horizontally or vertically, and there are values ranging from 0 - whatever value. the cells are conditionally formatted to show a gradient based on high or low values in the series.... now can we have a bar chart which can Automatically Set Chart Series...
  7. N

    Date and Time Issue

    Please Refer to the post... http://chandoo.org/forums/topic/how-to-convert-a-string-which-has-both-numbers-and-text-to-a-time Any Help will be appreciated.
  8. N

    how to convert a string, which has both numbers and text, to a time?

    we get scanned documents and the files does not contain standard formatting for the fields, although text only or number only fields have no issue but lately got stuck on this one think. After converting the time field which is in the format "12.30am" & "1.30pm" we get something like "1200am" &...
Back
Top