char

Greetings, I'm trying to replace an unusual character ( ≠ ) in a sheet with vba. It's proving to be very difficult. Excel's default search and replace works fine ("<>") but I prefer automating these processes with vba. I have been very successful using the replace and instr functions for =, < ...

Hi, I'm trying to use the REPT function to create bar charts in cells to show project completion status. This works fine when I place the █ character in a cell and then use a reference to that cell in the REPT function. However, I would prefer to use CHAR to locate the character so that there...

Hi, in column A I have email address: pawel.tom@gmail.com aqwe_12@yzf.pl audi_adm_2@audi.com In column B I want to get only: gmail yzf audi How can I do it?

Hi All, I have a chart that has a series of values as the underlying selected data. I want to be able to see the full series, half the series, and a quarter of the series. Thanks to the geniuses of this forum, I have been provided with the following codes to make that happen. Sub HalfRange()...

HI Probably simple I just cant figure it out. I have cell content of a variable length string and I need to extract all text after "///" an example is below: <tbody> 897/C///Amarnath Leena CD20110316 09105348 I need to pull everything after the "///" Another example would be: <tbody>...

this is a copy of a previous post on summing a text string. Example: 21+12+13..... The string is of variable length with the possibility of 256 or more chars. Try Jindon's Function SumInCell(ByVal txt As String) As Double SumInCell = Evaluate(Replace(Application.Trim(txt), ",", "+")) End...

Hi, I have an error in the following formula: ={CHAR(MODE(CODE("M2:"&ADDRESS(ROW(M2),COLUMN(AF2)-COUNTBLANK(M2:AF2),4))))} The problem I'm trying to address is finding the most popular letter in a row of letters. Each cell in the row contains only one letter, but in some cases the letter...