All,
I am looking to rid myself of extra information in a column, and doing
so in a Macro
Here is what I have in column A
SELECT Column1, Column2 From Mydb.Myspace.My table Where Column1 =
'Hello"
I want to frind the FROM word (There is only one in the cell) and
delete all to the Left including the from
Then Find the WHERE (If it exsists) and delete all to the Right
including the WHERE
And I would end up with column A
Mydb.Myspace.My table
I have several examples of removing single char or commas from the
column, but not entire words.
Any ideas?
Doug
Bookmarks