character

Hello, small problem: Right(elem.innerText, Len(elem.innerText) - InStrRev(elem.innerText, " / ")) This successfully pulls right of the "/". How would I adapt to include the "/" as well? Thanks.

First post. Need to get LUN ID from a Disk UID initial DISK UID is a string of around 20 odd characters. I only need the last 6 which i can do. but then i need to convert that 6 digit string into a 3 character string. like so initial 6 digit string 3 4 4 5 3 4 only intrested in characters 2...

Hi in Column A, I have a mixture of 7 and 10 character long project numbers. In Column B I want to reference all project numbers to a uniform 10 character format. With the 7 characters ones I want to add “/04” to them. Can this be achieved with a LEFT and IF formula? Thanks

Hi Is there a script that would look at say, column F, and if the number of character length is 3 or less, replace that number with 2100? Thanks Jay

Problem: In Google Sheets, I use the IMPORTDATA function with an API call to a 3rd party data provider that frequently produces a text string that is longer than the cell limit of 50,000 characters. I have no control over the length of the text string that is provided to me, and when the...

Hello, I've got a weird problem where I'm struggling to detect the last occurence of the character "-" and replace it with "x". Does anybody have a way to take a string and replace only the last occurence of that character? (I've gotten a replace function to work, but it replaces ALL...

This appears to ONLY happen with Windows 10 Enterprise 64-bit. MS Office 2016 32-bit The problem is using a Password Char for a textbox. This Windows OS will not read characters in a masked textbox. Is there a way around that? If I remove the character mask then the textbox works fine. But...

As always, any and all help and suggestions are welcome. :) I'm very happy that this weekend is almost over, because my brain is full of Excel and it's made me start drinking wine already. So, in a quest that is somewhat similar to an earlier one, I need to turn all cells a medium light gray...

What formula do I use to add a character to the end of a cell if that character is not already there? Example: there are multiple rows... some end in "NC" and some end in "N". I'm using the quotation marks to designate that the cells end in the letters. The quotation marks are not in the...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> My data are in the column C:P, require results in the Column V:X</SPAN></SPAN> For example count max occurrences of the "last to first" character find in the each row</SPAN></SPAN> Row 6 last to first character "1" max occurrence=1, result In...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> My data are in the column C:P, require results in the Column R:T</SPAN></SPAN> For example count max occurrences of the 1st character find in the each row</SPAN></SPAN> Row 6 1st character X max occurrence=1, result In S6=1</SPAN></SPAN> Row 7...

I hope someone can assist with this question. I require to understand the number of characters behind the final '\' character. Example: Monday\Tuesday\Wednesday Answer in next cell = 14 (14 characters behind the final '\') Or is a possible solution to count where the final '\' is in a...

Hi everybody I have generator password in excel, but sometime, my password have dulicated character, which make my password less secure, can any one help me with the fuction to help my password not have a dulicated character. My password is in G1, the ingredient to make my password is from D5 to...

Hello, I am first time poster looking for help with a formula which uses a sumproduct and vlookups: =SUMPRODUCT((VLOOKUP(__,__:__,{2,3,4,...},FALSE)>0)*VLOOKUP(__,__:__,{2,3,4,...},FALSE)) Here is a simple example of the formula in action: https://i.imgur.com/i49xcNl.png While the formula...

what's the vba code to remove any character after the last "" in a string?

Is there a way to insert a character while the user is still typing. For example if the user is entering the date, automatically insert either a "-" or "," or "/", or a "." after the first two characters. For this instance I just need to insert the character after the two digit month followed by...

Hi, I have made a code where if I were to write out a name in a textbox the first letter will be capitalized. It also capitalizes the first letter whenever I add a space between names. So, I am having this problem where whenever I put a special character or a number (For ex...

Been trying to figure this out lately- I have excel data in a unique system where a cell has multiple values for SKUs For example 1231223525 123512AA12 bR1124ABAGGA i was hoping if there is a formula or a Sub where we can run it on the cell like MID(A1, (LEFT(A1)=",") + 1, LEN(A1)) to...

Hi. I want to align the text in a column so that a specific character (±) is in the centre. The number of characters either side will vary depending on the value, # decimal places etc, but the one constant will be the ± character. This is an example of some data: <colgroup><col...

Hi All, I hope you can help. I've found below thread, and have a similar challenge. https://www.mrexcel.com/forum/excel-questions/590962-typewriter-animated-text-excel.html Instead of writing the text in the VBA code, I would like to pick up the text from another cell in the workbook. It...