Convert text

[maclachlan19]

I need a little help writing some VBA.
I have text in Column A1 to A300
I want the clean the text
More specifically - convert all letters to lower case
- Remove any non letter characters
-remove any leading or trailing spaces
I would like the output to be pasted in B1 to B300.

 

[Rick Rothstein]

You say you want to remove any non letter characters, but you also say you want to remove leading and trailing spaces... does that mean you do not want to remove internal spaces even though they are non letter characters?

 

[maclachlan19]

internal spaces are alright, I just want to trim the text on the bookends. The data coming thru has a bunch of leading and trailing spaces.