string formating

  1. J

    If period "." located in string, return "File", else return "DIR"

    Dear all, I have been tasked with reviewing network directories and files to etsablish when the directories and files were last accessed. This being in an effort to remove redundant directories and data that is no longer being used. I have used the command line to extract the required data...
  2. S

    Converting a string into a particular Date Format

    I have a large no of strings(left hand side of arrow) and i need to convert them into Date format(right hand side of arrow) in Excel. 19,690,408 --->> 04/08/1969 19,610,419 --->> 04/19/1961 19,560,107 --->> 01/07/1956 Can anyone help me with this? Thanks in advance.
  3. J

    Switching position of last name & first name strings without affecting position of an existing middle name string

    My data shows employee names in the following convention; lastname middlename firstname e.g. Persie Van Robin. I need to format the order of the name so that it appears as firstname middlename lastname e.g. so it appears as Robin Van Persie. A middlename will in many cases not exist. My macro...
  4. D

    Format String number in Textbox

    I have a textbox which contains a positive or negative number. But if the number is negative, rather than displaying a "-", for example '-.25', I want to display as (.25), in parenthesis. How can I do that?

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...