Hi All, reading thru the various thread cant really find the solution to my problem, my columns A has 2,000 rows, each rolls have a Blank Space after the text [Eg Call A1 (XXXX ), A2(YYYY ), there is a space after the XXX,YYYY), how do I delete the space for all the 2000 rows? Appreciate your kind assistance.