Excel: Delte Text from a column

Hey everyone, I am pretty new to VBA and I am wondering if there is a way to delete text from a colum that has both numbers and letters in it. For example, if the column is one that is holding weight values, I would need to get rid of all the lbs, LBS, lbs., etc from the column and leave only the text. Is there a way to do this? I don't have any code to post, because I have no idea how to go about starting. Thank you for any and all replies.

This question generated 42 answers. To proceed to the answers, click here.

This thread is current as of July 28, 2014.

For more resources for Microsoft Excel