Remove special characters and numbers

[Sufiyan97]

I want to remove any numbers (0 to 9) and special texts like * # - ; X from below data

Book1
	A
1	Description
2	CHECKCARD 1103 IN *J3 RESOURCES, 713-2900221 TX 55432860308200406920029 CKCD 7392 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
3	CHECKCARD 1105 eBay O*02-06012-0 San Jose CA 15270210310001147494941 CKCD 5311 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
4	CHECKCARD 1104 TX BD ENG LIC REN 5124403063 TX 55488720310091332000464 CKCD 9399 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
5	CHECKCARD 1105 GILLMAN HONDA HOUSTON TX 55310200310207098200075 CKCD 5511 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
6	CHECKCARD 1105 AMZN MKTP US*289V AMZN.COM/BILLWA 55310200311083703189089 CKCD 5942 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
7	CHECKCARD 1107 TST* RUDY S COUNT SPRING TX 02305370312500225745329 CKCD 5812 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
8	CHECKCARD 1106 AMZN MKTP US*287L AMZN.COM/BILLWA 55310200311083360221092 CKCD 5942 XXXXXXXXXXXX5599 XXXX XXXX XXXX 5599
Sheet1

 

[NdNoviceHlp]

why you wrote
"doesn't seem like this is what U want either..."
The code removed the "X" from TX which I believe stands for Texas which U may want to keep. Thanks for posting your outcome. Be safe. Dave

 

[Sufiyan97]

You are welcome & thanks for the feedback

You've BIG right

I am sorry
but what is meaning of "You've BIG right "

 

[Sufiyan97]

why you wrote
"doesn't seem like this is what U want either..."
The code removed the "X" from TX which I believe stands for Texas which U may want to keep. Thanks for posting your outcome. Be safe. Dave

Ohh That I didn't think
but any ways I wanted to extract only names so no need to keep TX or any other state like CA

 

[sandy666]

I am sorry
but what is meaning of "You've BIG right "

you are very right