left

Hello, I am using this formula --LEFT() instead of LEFT(), and I get different results, but I do not actually understand why. Can anybody explain what the -- does to the formula?

I've got this nagging situation/s. In my excel files I've this: examples in the tables are as below: Names FirstName MiddleName LastName Roberto Engelesias Darwin Subramurthy s/o Thirumurthy Abdool Kassim ibnu Murshid Azmi Bin Abdullah How do I seperate it into...

I have a large VBA project I'm working on that uses the "Right" function a lot. All of a sudden it gives me an error message of... "Compile Error Wrong number of arguments or invalid property assignments." When I try to compile, with the "Right" Function highlighted. What's really strange is...

Hi I created a conditional formatting based on the value of the cell excel would insert bar as below. The bar can move from left to right or right to left. My question can I create similar bar but move from bottom to top? is that possible? Thank you very much

Hello, I am looking for a formula that can find a certain work and return only 10 characters to the left of that word. For example OTHER INFORMATION.... FOR PO# 55222 FROM COMPANY Left of "From Company" I want it to return the PO# 55222 Any help would be appreciated Thank you! :) Carla

The following data is in a SINGLE cell. I'm trying to get the phone number from each line and output it as just a list of phone numbers in a single cell. FROM THIS: <tbody> (734) 435-8519 < Sent TXT 14/25/09 @ 08:54 (734) 917-1416 < Sent TXT 14/25/09 @ 08:54 (734) 742-6437 < Sent TXT 14/25/09...

Hi, The title says it all. I'm trying to extract the text between a character (character is "%") and the first space to the left of that "%" character. I figure it would need to include the left and find functions but I am having a hardtime figuring out how to put it all together. Any help...

Hello, Quick question. I am looking to do a multiple IF AND statement including LEFT. The below formula gives me a #VALUE error so I know I am doing it incorrectly: =IF(AND(C2="Blue",(LEFT(D2,1)="C"),"250",""),IF(AND(C2="Blue",LEFT(D2,1)="B"),250,"")) C2 has to be Blue AND D2 has to start...

Trying to create a new Access table based on the results of 2 join queries (see below). Each query individually runs fine with no errors, but when I use UNION I receive an error message "An action query cannot be used as a row source". Can someone help? Thank you! CODE: SELECT...

My Data Range is B2:G10 having 4 columns B,C,D & E. These 4 Columns are ‘continuous’ & have values which are either ‘INCREASING’ from B to E or ‘DECREASING’ from B to E. Reference range is from G2:G10 Output required: 1. I2=’Nearest’ value from B to E with reference to G 2...

I have numbers in column A that look like this <tbody> 13,065,102 13,165 4,051,065 600 18,013,092 </tbody> But when I click in the formula bar they are really this (real numbers) <tbody> 13065102 13165 4051065 600 18013092 </tbody> What I need to do is to is put the...

hi, i cant find it? i pressed f4 and it's not showing. also, before it disappeared, it was "free flowing" and not locked as it usually is at the bottom left corner? how do i lock it? (first i need for it to show up, my first issue)

Hello all- Trying to cross reference one worksheet with another(old format) and return the relevant data that is in the left column if they match. HELP

Hello. In cell A1 (Sheet 1) I'm receiving a huge HTML code. I need to extract somehow values for 'top' and 'left' without % suffix. for: style="top: 54%; left: 13%; I need only 54 and 13 Results should be placed in column B for top values (B2:B300) and column C for left values (C2:C300)...

Hello, I can't seem to figure out where to place the "Left" function in the below formula. Cell "EA7" contains a number followed by three letters. These letters will only always be one of the four. "Eng", "Out", "RWK", or "Cust". Not all the numbers in Column EA will be followed by these...

Hello again, You guys are so helpful! I currently have the following formula on a cell: =INDEX(DI1:DT1,MATCH(MAX(DI2:DT2),DI2:DT2,0)) It is working great. However, I would like to add additional functionality to the formula, where 19 characters of the output are removed from the left, and 31...

Hi, What I a after if possible please is a formula where it can work out how much money is left that month. I would like to enter an "income" (that is variable) figure in a cell and in a return cell get how much of that is left depending on today's date with any upcoming bills for that month...

I am making a userform in excel using VBA. I want whenver a textbox1 is left blank after clicking a save button a pop up window is trigerred saying "the textboox1 cannot be left blank" I know how to do this Function ValidateForm() As Boolean ValidateForm = True If Trim(a1.Value) =...

Here's my formula right now: =COUNTIFS(Q$2:Q$1127,$B1136,F$2:F$1127,"Y",$A$2:$A$1127,"Provider") I want to COUNTIF $A$2:$A$1127 contains "Vendor" OR "Investor" along with the conditions for ranges in Q and F. I tried...

I have a few active-x buttons in a .xlsm file that I sent to a coworker. He can execute the macros manually so I know macros are enabled but when he clicks a button the button shape and text appear briefly above the actual button and a bit to the left and then vanish and NOTHING ELSE HAPPENS...