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

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

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

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

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

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

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

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

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

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

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

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

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

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

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"))"