Delte Text from a column

[TayoMayo]

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.

 

[hiker95]

Rick Rothstein,

hiker95,

Can you do me a favor? Would you run the code I posted in Message #22 against the workbook you downloaded and tell me if it works for you or not ? Thanks.

Sure.

Sample raw data in Sheet1:

Excel 2007
	C
1	475
2	347 lbs
3	53kg
4	4753kgs
5	4 lbs
6	534 LBS
7	53 KG
8	453 LB
9	45 KGS
10	34 LB
11	53
12	453
13	45
14	34
15	53
16
Sheet1

After your LeaveNumbersOnly macro in reply #22:

Excel 2007
	C
1	#N/A
2	#N/A
3	116.845
4	10478.57
5	#N/A
6	#N/A
7	116.845
8	#N/A
9	99.20802
10	#N/A
11	#N/A
12	#N/A
13	#N/A
14	#N/A
15	#N/A
16
Sheet1