text formula

  1. J

    Creating a UDF to execute a formula

    I am trying to create a UDF that executes the following formula but I am unsure how exactly to structure the code for UDFs, more up to speed on run-of-the-way VBA macros. Any guidance would be appreciated...
  2. J

    Break up and count concatenated string - text formula

    I have a 5,000 strings formatted as such: (in one cell) 0 0 0 0 0 0 0 12 12 12 12 12 15 15 15 15 18 18 25 25 25 25 25 25 25 100 100 100 100 100 100 100 100 These strings may be as long as 300 unique numbers with spaces in between each number. What I want to do is convert each string to the...
  3. tlc53

    Data Validation - Date and Text String

    Hi there, I have Data Validation set on my date entry cells so only a valid date can be entered. The formula I am using is =AND(ISNUMBER(E158),LEFT(CELL("format",E158),1)="D") and this works fine. However, when no date has yet been entered, I would like the cell to read "Enter Date". I tried...
  4. S

    Need help understanding SUBSTITUTE MID SUBSTITUTE REPT formula

    So yeah surprisingly I didn't find any explanations on this semi complicated formula =SUBSTITUTE(MID(SUBSTITUTE("_" & B7&REPT(" ",6),"_",REPT(",",255)),2*255,255),",","") So here I used it to extract a value between "_" characters. But I want to make other additions/operations to this formula...
  5. E

    formula or macro to extract a code in the format “03 30 00” from various text data in multiple variations

    I need a formula or macro that can extract a code in the format “03 30 00” from various data in text format in multiple variations, such as; “033000 CAST-IN-PLACE CONCRETE” “Section 03 30 00 CAST-IN-PLACE CONCRETE” “03 30 00 CAST-IN-PLACE CONCRETE” “ 03 3000 CAST-IN-PLACE CONCRETE” with a...
  6. C

    Extracting a character string from the Midde

    Hi, I've reviewed previous forum posts and attempted to figure out how to do this. No luck. I'm looking for a formula(s) that can extract the a. choice, the b. choice, the c. choice, and the d. choice (see example below). It does not need to be an all encompassing formula (if that's easier for...
  7. K

    Pulling in a custom format using a fixed or text formula?

    I am attempting to automate some reports that I do in excel by creating a format I can simply copy into word. In the word doc since the numbers are high numbers I translate to a more simplistic form, for example ($14,175,380 would translate into $14.2M). I am using a custom format IN EXCEL...
  8. A

    Subtracting Fiscal Quarters from eachotehr

    I am looking to just calculate the column in red below (Column E) in a basic excel spreadsheet. So I have the information in column A which is converted from date to fiscal quarter for column B. The same applies for column C which is converted into fiscal quarter (Column D). The end result is...
  9. C

    Drag down not generating correct results?

    Hi, I am using the formula =TEXT(*cell reference*,"dddd") to display the date in the cell reference (in format xx/xx/xxxx) as its corresponding day of the week. It works great when I manually type it in, but when I try to drag down the formula to other cells, it is just displaying the day of the...
  10. G

    Text Function in Excel do not recognize YYYY as Date

    Hello All, I have a problem with my Text function in excel. When I type Text(02/12/2014,"ddmmyyyy") the function show me 1202yyyy. I know that there are other posts about this problem here and on google, however none of them seem to solve my problem. Solutions that I already tried: When I...
  11. F

    Replace in VBa

    Hi, in Excel I'm using formula: A2 = REPLACE(A1,1,FIND(":",A1),""). Now in VBA I did like: ws.Range("A2").Value = "REPLACE(A1,1,FIND("":"",A1),"""")" and it's ok. How can I directly assign value from formula to my variable??? I had something like below but is wrong :/ Dim new_value as...
  12. J

    Formula with multiple criteria (including text)

    Hi, I need to create a formula that is returning "term 1" or "term 2" if two criteria are met. First criteria is that certain cells contains a date (in example N10). And second criteria is that another cell (in example P10) should contain at least one of the words that are listed in column of...
  13. Y

    Need to select and copy characters after a : then paste them in adjacent cell

    I felt sure there was a standard formula for this one but I can't find it. Any help would be most appreciated. I have a series of cells that contain a question and an answer. At the end of each question is a colon (:). I need to copy the answers - that is the cell contents that come after the...
  14. E

    text determines value

    Hi all, New to the forum and also Macros. I am trying to write code to make a cell default to a negative value based on the text of another cell. For example: if the cell states "EXPENSE" then the offset(0,1) will be a negative figure when the numbers are entered into that cell. Any help...
  15. J

    TEXT formula in VBA

    Why won't Excel VBA let me use the following formula in my code?! Range("P2").Formula = "=UPPER(TEXT(DATEVALUE('Front Sheet'!$J$1),"mmm.yy"))"

Some videos you may like

This Week's Hot Topics

Top