benong
08-22-2010, 09:50 PM
hi,
i have rows & rows of string in column A.
..2 0021 313922364983 PTR KWB900001 MAIN 1 PCE X 18.05.2010 0
....
....
Every rows contains different set of data, but this word "KWB900001" appears on every row.
So now, on every row, I want to remove all the characters at the back of the string, starting with this word: KWB900001
eg. ..2 0021 313922364983 PTR KWB900001 MAIN 1 PCE X 18.05.2010 0
become -> ..2 0021 313922364983 PTR
Can someone guide me on this, thanks.
i have rows & rows of string in column A.
..2 0021 313922364983 PTR KWB900001 MAIN 1 PCE X 18.05.2010 0
....
....
Every rows contains different set of data, but this word "KWB900001" appears on every row.
So now, on every row, I want to remove all the characters at the back of the string, starting with this word: KWB900001
eg. ..2 0021 313922364983 PTR KWB900001 MAIN 1 PCE X 18.05.2010 0
become -> ..2 0021 313922364983 PTR
Can someone guide me on this, thanks.