Linked Questions

can you help me on this? I have a simple string: str="Hello World"; I want to split it as that : array= str.Split("",System.StringSplitOptions.RemoveEmptyEntries); result shoud be array[0]="H" ...

How can I replace more than one thing in a string variable? Here my example function in VBA: Private Function ExampleFunc(ByVal unitNr$) As String If InStr(unitNr, "OE") > 0 Then ...

I have created a VBA code to remove all special characters available in a column. As an example I have a Alphanumeric character with some special characters in every cells of a column: Suppose in a ...

I have a number (say 5) which I would first like to convert to binary (101) and then split into an array of bits {1,0,1} or Booleans {True,False,True} in VBA Is there a way to do this without looping?...

I have this textbox named txtnum in which I have to enter a 15 digit number and allocate it to variable num. I want to split the number into individual characters so that j can carry out calculations ...

Given a word, I need a function that returns the structure of the word in terms of vowels and consonants. "c" stands for consonants and "v" for vowels. If the letter "y" ...

I have two columns and I am trying to union the text in these two columns and store the result in the third. In the example data below, Union is the output I am trying to achieve. When I concatenate ...

I have this code that replaces all accented characters except in row 6. However, this macro takes a long time because it goes through every cell/letter, is there any way to make this any faster by ...

I'm looking for advice on breaking up a very large string into many smaller strings. As an example, I have a string of 5000 characters. I have to split that string up into a sequential array of ...

Lets say I have a database of words in Sheet2; it goes from A1 to B200. I need to randomly select one of those words; and show it in Sheet1. Moreover, I need to have on blank cell between each ...

I'm trying to prepare a spreadsheet for a report in excel vba. Unforturnately there are some wierd characters here that need to be replaced. Easy enough, except for this chracter: ¦ I can't seem to ...

I have a VBA formula-function to split a string and add space between each character. It works fines only for an Ascii string. But I want to do the same for the Tamil Language. Since it is Unicode, ...

Ok, To all those who may come across this question, this is a problem I have been banging my head against for the past two weeks and have made little or no progress, so any help would be extremely ...

I have been using some useful VBA code by PEH that uses regular expression to extract the number of instances of a specific element in a chemical formula, see: https://stackoverflow.com/a/46091904/...

I have a procedure, that generates a random string without any delimiter. I store return value of this as a string, but I would like to split this text into characters and after that examine each ...