I need to remove both blank spaces and numbers from data (leaving only the letters). I have listed an example of the data that I need to have this application performed on. Please note that there are also spaces before each number. Could some one please provide a formula/macro that would do this task.
Thanks Brent
1 mlkkklltll tvfalltvgi cgsflplpka saaaliyddf etglngwgpr gpetveltte
61 eaysgryslk vsgrtstwng pmvdktdvlt lgesyklgvy vkfvgdsysn eqrfslqlqy
121 ndgagdvyqn iktatvykgt wtllegqltv pshakdvkiy vetefknsps pqdlmdfyid
181 dftatpanlp eiekdipslk dvfagyfkvg gaatvaelap kpakelflkh ynsltfgnel
241 kpesvldyda tiaymeangg dqvnpqitlr aarpllefak ehnipvrght lvwhsqtpdw
301 ffrenysqde napwaskevm lqrlenyikn lmealateyp tvkfyawdvv neavdpntsd
361 gmrtpgsnnk npgsslwmqt vgrdfivkaf eyarkyapad cklfyndyne yedrkcdfii
421 eiltelkakg lvdgmgmqsh wvmdypsism feksirryaa lgleiqltel dirnpdnsqw
481 alerqanryk elvtklvdlk keginitalv fwgitdatsw lggypllfda eykakpafya
541 ivnsvpplpt eppvqvipgd vngdgrvnss dltlmkryll ksisdfptpe gkiaadlned
601 gkvnstdlla lkklvlrel
Bookmarks