chars

Greetings... So here is my issue I am trying to resolve. I want to capture data from my a serial port and place the data in different cells. I am using an Arduino in an application where I do a serial print, in that print I am sending two bits. Each one represents an input pulse to the Arduino...

Hi I have cells as below. I know clean() function will not clean these chars and I will need to do substitute() these chars with "" for example. But I have 2 questions: 1) does that mean I have to create a new substitute() function for each cell? knowing these cells are having different chars...

Hi all I have a column that contains free text, I need a way (using vba) to find specific chars in this column the format of the text chars will always be like .. one Alpha and 7 numeric(together).....Examples of this is are D1564567, A1235567, all the way through to Z2356457 and if and when...

I have one column (9000+ rows) thatcontains data prefixed; Ann or Annn or Annnn chars. e.g. Z12 and/or Z123 and/or Z1234 which I wish to delimit into separate columns A data example of one cell is; Z12,Z123,Y1234,Y5678,Z1111 up to around 10 occurrences I havebeen using a formula to delimit...

Hello, Column I have some info + acc number. Id like to strip this column of everything beside acc. how delete everything beside last 32 chars? =Right(I2;32) but to all in column I and with VBA Thank You :)

Hello, I like to extract 8 characters from a string in cell X. Strings are different lenght but last 10 chars ale always 10. I need 8 chars before last 10. example string and what I need to extract (in bold) random_name_some_data-123456782017121299P Please help :) Best Regards W.

I really need help with this one, I have run into the 255 char limit of passing a string from excel to word. The following is what I have attached to the print command: Private Sub cmdPrint_Click() Dim wdApp As Object, wd As Object, ac As Range On Error Resume Next Set wdApp =...

Hi I have a border around a merged and centered cell group. The group takes a maximum of 18 characters but could contain as few as 3. When printed using say 3 chars, the border looks a little odd as it covers the entire area for the full set of 18 chars. Is there a way to expand or contract the...