Hi!
I have many columns with
A: ALPHANUMERIC
B: STRING
C: WORD , ETC
All i need is to take off all the <SPACES> at the end of a string or word in a column
Problem:assuming <SPACE OR SPACES> means " "
A
12 DE 2345 F45 68<SPACE>OR <SPACES>
2324 DKFJ 34 KJK 3KJJK<SPACE>OR <SPACES>
B
Mr. Antonio Fernandez<SPACE>OR <SPACES>
Mrs. Stacy De Maria <SPACE>OR <SPACES>
C
New York<SPACE>OR <SPACES>
Texas<SPACE>OR <SPACES>
RESULT:
A
12 DE 2345 F45 68
2324 DKFJ 34 KJK 3KJJK
B
Mr. Antonio Fernandez
Mrs. Stacy De Maria
C
New York
Texas
Thank you
Appreciate your early reply
Note: Please refer to the attached file if am not clear in defining my problem
Bookmarks