underscore

Hi Folks I've been scouring the net but without success. I'm hoping the genius's here will be able to help me :-) I'm trying to mock up some work for my daughter to help her with Synonyms and Antonyms. What I would like to do, if possible is: Column D looks at Column F (which will be hidden)...

Hi Can anyone help with a VBA code that makes a Hyperlink to cells? This Workbook is a staff list where in column "E" it is possible to use a Hyperlink next to each person to see a photo The path to the file is e.g. C: \Users \ Division \ Staff \ 38543_Benny_Mcgee \...

Hi Excel master, I've been struggling to figure this out and so I am requesting you help to write formulas based on this particular value: For example: CMR_01_28988699_0 Questions: 1. Formula for counting the number of characters after the underscrore after R? 2. Formula for counting the...

Hello I have a macro that create automatically new Sheets and on each Sheet create a Table The Table Name is based on Sheet Name ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:G1"), , xlYes).Name = "Tab_" & ActiveSheet.Name Excel replace space and other characters on the Sheet name with...

Hi Folks, I have a TextBox/SpinButton Combo that works fine, except that I notice an odd artifact when directly/manually changing the (numerical) value in the TextBox... It acquires an Underscore during input. This does not happen when changing the value via the SpinButton. :confused: The...

I have strings that I need to pull the first word out of. The problem is, that the first word is either delimited by a space, or an underscore. I have been using the below formula to find the first word if separated by a space, but unclear how to add the OR to look for an underscore...

I have a large set of names, and I need to Transpose those into Last Name, First Name. 800 of which have either two first or split last names. I'm currently going through and adding an underscore _ but really want to convert the underscore to the non-breaking space. Everything I have tried so...

I have an getpivotdata formula that works quiet well for multiple items but fails to return data for one item. The main difference between the item that fails to return a result and the others is that it contains an Underscore. =IFERROR(ROUND(GETPIVOTDATA("Events",Changes!$C$503,"Last changed...

Is it possible to get the variable last text in a string after an underscore. There will always be an underscore before the last word but the length of the text is variable and the text contains letters and numbers. I would like to offset the returned text i.e C2 contains the text and G2 is...

I need to replace a string like below: IpArId to be converted as Ip_Ar_Id Wherever the upper cases identified in a string to be prefixed with "underscore" ("_").

Hi! Here's an easy one for you guys! I have this table row of which I want a range including only cells without the underscore char. The underscores appear in no particular order. Example: Apple|Orange|Apple_Nutrients|Orange_Nutrients|Banana|Banana_Nutrients|Banana_Count Desired range...

I am in dire need of help.... I am in a GIS class with a homework assignment and in need of help with Arc Catalog. In an excel table I am needing to find and replace blank spaces with an underscore in fields. I would really appreciate some excel help. Thank you sooo much!

Hi, I am trying to find the first word in a cell before an Underscore, the words I need to find are varying length including numbers before the underscore. I don't want to extract the word, I just want to find the first occurrence of the word and set this word as the word found so I can use it...

Hi all, I have been trolling the forum for the last few hours trying every .replace code I could find but to no avail. I would like to insert code into an existing macro that calculates sheet 2. The sheet is full of index functions that pull categories with underscores from sheet 1...

Hi Guys, I've been searching around for a few days but can't seem to find what I am looking for. :confused: I've created a worksheet with several drop down lists that are INDIRECTly related to eachother. As there are several hundred options in each list, I would like the user to be able to...

How can I define an underscore (or any other character for that matter) to be a word separator? I have sentences such as "... use the vendor_name in the Initial_Load file ..." and both underscored compound words fail the standard spell check, but would succeed if treated separately. This is for...