DaveK
07-24-2008, 09:53 AM
I think this is probably easy... if you know how to do it! Can someone help with this... it would be much appreciated! THANKS!
I'd like to know how to have a VBA to look at each and every character in a Selection of cells down a column, and do the following:
1) read the contents, cell by cell, character by character within each cell.
2) allow me to do a check of every character, character by character, to see if it matches a specific character I want to find.
3) output each character of the cell into an adjacent offset column to the right of the current cell, as long as the character is not the special character.
4) checking each character, outputting the same character into the adjacent cell... UNLESS it matches.
5) if it matches the special character (which I want to be able to change), REPLACE that character with the "replacement special character".
6) continue character by character in the cell, outputting all non-matched characters exactly into the adjacent column cell.
7) do this down the column for the current Selection.
So, for example :
first second third fourth first second third fourth
one, two, three one5 two5 three
James,, Wilson Jones James55 Wilson Jones
if Column A has as above, then the VBA writes column B to be as above when the special searched for character = comma. And since we have some characters matched, replace that character with the "replacement special character" = 5.
Now here is really where I need more help as well.
Now for another program, I also want to be able to do similar, but in this case, scan down the current Selection column, and output to the offset column the contents character by character... in DECIMAL value of each character, separated by a space between each decimal value outputted.
In other words,
one 111 110 101
Hello<CR> 72 101 108 108 111 13
I hope you can help me.... THANK YOU ALL sooo much.
Dave
I'd like to know how to have a VBA to look at each and every character in a Selection of cells down a column, and do the following:
1) read the contents, cell by cell, character by character within each cell.
2) allow me to do a check of every character, character by character, to see if it matches a specific character I want to find.
3) output each character of the cell into an adjacent offset column to the right of the current cell, as long as the character is not the special character.
4) checking each character, outputting the same character into the adjacent cell... UNLESS it matches.
5) if it matches the special character (which I want to be able to change), REPLACE that character with the "replacement special character".
6) continue character by character in the cell, outputting all non-matched characters exactly into the adjacent column cell.
7) do this down the column for the current Selection.
So, for example :
first second third fourth first second third fourth
one, two, three one5 two5 three
James,, Wilson Jones James55 Wilson Jones
if Column A has as above, then the VBA writes column B to be as above when the special searched for character = comma. And since we have some characters matched, replace that character with the "replacement special character" = 5.
Now here is really where I need more help as well.
Now for another program, I also want to be able to do similar, but in this case, scan down the current Selection column, and output to the offset column the contents character by character... in DECIMAL value of each character, separated by a space between each decimal value outputted.
In other words,
one 111 110 101
Hello<CR> 72 101 108 108 111 13
I hope you can help me.... THANK YOU ALL sooo much.
Dave