characters

I have a column of data that shows whether a value is over or under a target value. I have the over values (>0) highlighted in red and the under values in green. By "highlight" I mean the fill color, not the color of the characters themselves. The column has a header with the characters "O/U"...

Is this possible to remove anything not 8 characters long from a cell in a column. for example Column H has 4 rows (there is data in columns A-G as well but I am only looking at column H to make this change): <colgroup><col></colgroup><tbody> 1. NBS CM XTEND 14260 FXC041465 FXC041466...

I have tried to use the Substitute function to replace part of a file. I need to do this in VBA with a UDF or something. I want to search for this string (the characters between < employeeid >< /employeeid > could vary - that is the wildcard part) < employeeid...

Hi, I'm trying to get just the filename and i used this formula, =MID(CELL("filename",E30),90,13). the formula works fine until there's more characters then it doesn't capture what is need and i would need to change the "13" to a 14 or 15 depending on how many more characters. I know the...

Is there a convenient way to split text in to two columns using the second space from the left. The text is not fixed length. There are no potential delimiters other than space characters. I am using Excel 2016 on a Windows 10. Thank you

Good Morning, I am terrible with formulas and was hoping to get some help. I'm trying to create a formula that counts blanks as well as any cell that contains these characters ("O", "TR", "LD", "D"). I keep getting a too many arguments error. Is this even possible? Here is what I thought the...

Excel 2013. My user has a cell in which he enters contract numbers one after another in the single cell, ie., 123456, 234567, 345678, etc. The cell is 15 characters wide and the default height. He does not want the cell size changed. Each day, or several times a day, he has to add a new...

Hi all, I have been struggling for a few days with this issue and I'd really appreciate some help: I have 64 columns of data in one sheet with which I want to build a pivot table. In this pivot table I need to add a filter for the Product IDs columns and I filter out all the Product IDs that...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> In the cells C6:F19 each row is filled by 3 characters 1, X or by 2, I need a formula, which can search each row and give a missing character result in the column H Note: if non of 1, X and 2 is missing I want it return "Nothing"</SPAN></SPAN>...

Hello, A field in my database is for a control number. The control number varies in length, from 16-20 alphanumeric characters. That control number always* ends in 6 numbers, which I extract and copy to the clipboard using VBA. *On rare occasion, an alpha character (always an alpha...

I would like to sum three unique characters in a range: D1-D70. The characters are *,+,- Thanks.... Doug

hello please help dear helpfull friends i need a macro code to delete some letters with a code. for example i want to delete "a, r, ş, ö, ğ, o" in a excel document. i want a code that i can change letters , they can be less or more than these. so i will write letters that i want to delete and...

An error have been annoying me since I recently updated Excel. I have a string that has more than 255 characters, and I was using .AddType to write in a cell like this: formula = "a1,a2,a3,...,a200" 'string has near 600 characters With ws.Range("C8").Validation .Delete...

Hi I am looking for a list of characters that is used in Excel what for what reason. For example, I know "$" is used to lock a cell, "!" is used to refer to different tab, etc. Tried to google but got different things. Thank you very much

In the attached sample file, I need to separate Column B (Asset Description)into 3 columns. The maximum number of characters per column is 43 characters. However, it is important that no words are split down the middle. If the original data is less than 43 characters to begin with, it can...

I am trying to extract another set of characters from this same line: MECH~CDA-CUP-PF~1 - CUP0915.2XL - Copper Reducer (P) AddFormula TopLeft.Offset(1, 2).Resize(RowCount, 1), "=IFERROR(MID(AA" & Row & ",FIND(""`"",AA" & Row & ")+1,FIND(""~"",AA" & Row & ")-1-FIND(""`"",AA" & Row &...

I have the following VBA code: AddFormula TopLeft.Offset(1, 1).Resize(RowCount, 1), "=IFERROR(LEFT(AA" & Row & ",FIND(""`"",AA" & Row & ")-1),"""")" This is the cell it is looking at: MECH~CDA-CUP-PF~1 - CUP0915.2XL - Copper Reducer (P) I want the formula to extract the first characters...

Hello, Small problem. I have wide table for punching data. For many columns there is the same two word as headers. (the dates might change so can't use formula in the tableheaders). Creating the table will then leave me with: Budget | Actual | Budget1 | Actual1 | Budget2 | and so on. So I...

The problem, I think, is that I'm ending up with illegal characters so can't use the string as a range name and I don't know where the characters are being inserted. I also understand a UDF can be created to clean the string, but I simply can't figure out to use the UDF with VBA. Help. TIA...

Tell me, are there any formulas that can implement this?