HOW TO: "If cell contains specific text display the immediate next word after it"
I have an excel file with each individual cell filled with data as it follows: Alejandro - GREEN Daniel - RED Sebastian - BLUE What I have been trying to do is to use a formula to extract the upper case value thats after the "-" immediate to the specific name of the person. At the moment I have the formula: =IF(COUNTIF(F3:F20,"*"&"Daniel"&"*"),"Yes","No") Which would simply return "Yes" if the cell contains the name Daniel, what I dont know how to do is to replace the "Yes" for a formula that would give me the "RED" in return. I know the formulas Left, Mid and Right are probably the way to go but since the separating character appears 3 times in a single cell (it being "-" I THINK) I have no idea how to stablish to use only the one after the specific name, and return only the very first word next to it (RED in case of Daniel). For this I have the formula =MID(M26,FIND("-",M26)+2,3) Which would give me GRE (3 characters only, dont know how to make it dynamic length) and would only return the very first entry as opposed to it being the one after the specific name, kinda close but no luck yet :/ Is this even possible? Edit: I attach my original file, I didnt before because the formula get so convoluted with other stuff I tried to keep it simple, basically its the formula on column O where i would replace the ":D" with the formula that im asking about.User Defined Function not showing with up "="
I have a few UDFs' that i have written for practice since i'm just getting into the programming portion of VBA. I have 3 Projects in my vba window. 1 for macros, 1 for my UDF, and the last one is whatever workbook i have opened. My question is how can i get my functions to show up when typing "=". I have searched google and the only answer that i came up with is i have to attach the module that has the function into the current workbook. My functions do work and show up when using "=" but it is a little annoying to have to attach them to every workbook i create since im dealing with new and multiple workbooks everyday. I also know that the "insert function" is under the formula tab and that works as well but still an annoyance. Just seems like there is an easier better way. Yes the functions are public, No the module names are not the same as the function name.
"REPLACE" issue on Microsoft Word
Hi everyone, I have a long text filled with dialogs. Dialogs are written wrong, ending with ".»" instead that "»." I tried the replace function, to massively substitute .» with »., but it replaced them as ". Why this happens? How can I effectively replace it? Thank you Roberto
how can i print file name by default for all excel sheets?
I need to print the file name on all the workbooks, but i have to insert the same every time i open a new file. Is there any option by which i can put this setting in by default so that each and every excel file prints the file name. pl helpExcel Functions
Hey there! I'm really new to Excel and I am trying to track my stats at work and I need to use an IF function but I'm not sure how to do it. I would like it so for example, if my TB% is 82% or higher the cell is green or if it is 81% or lower it is red. Any help would be appreciated :) Thank you!Invoice generation in Excel
I am looking for help! I am trying to create a template where my vendors can enter their raw invoice data to excel, and it gets translated to the 2nd tab invoice and I am running into the below issue: -some data consistently is only for 30 rows but then others will have upwards of 800 How can I format this, so that despite the amount of rows of data, Excel will create additional pages/tabs to accommodate the additional lines while maintaining the printablity and final total at the end of the invoice?
