remove trailing returns from a string

[reedssr]

Rtrim does not work to do this and i have other returns in the text i do not want to remove. I tried using replace and specifying the start location, but it cut the entire string and only ended up being the length from where I specified to start the replace from. I haven't done a ton of string manipulation in VBA, i know how i could do this in several other languages, but does anyone know how to do it in vba?

 

[scrupul0us]

Have u tried just TRIM()?

 

[reedssr]

yes, it only trims white space, white space being spaces, not carriage returns or which charachter chr(10) is. I was thinking of using instr then mid to trim off the railing return chars

 

[KenWright]

Trimall

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

 

[Gates Is Antichrist]

FWIW, my approach would be similar, but not quite the same: search(char(10),A1) and left(a1,....

You don't have to use VBA for this; I refrain from VBA when an on-sheet solution is available.

Nonetheless, McRitchie's work is fine, if you do go that way.

 

[reedssr]

i got it to work by using instr and mid to check just the first or last charachter and if it was chr(10) then do a mid on it, thanks for the other suggestions