Thank you Ballardw, I'm just trying to remove the space after copying my data from the cells. (I have about 500 rows of data) Excel example below: Ifnum=' 0857794 'then S_ANG= 45 Below is how the data looks when I pastes into thesasWindow If NUM=' 0857794 'then S_ANG= 45 ; Im just trying to remove the extra space in between the quotes Thanks again for your assistance.
... View more