Removing numbers at the end of a cell

[jeremyr863]

Hello all,

As the title mentions, I am trying to remove all numbers at the end of a cell. Not every cell ends in a number and most of the time each cell contains numbers. These number are useless for our purposes and need to be deleted, datasets typically are received around 10k - 100k cells.
For reference here is an example of what the data can look like, these are fictitious addresses:

40610 Dog Rd 352

205 Scott Ln 66

35150 Trace St

70 Cut off Boulevard 6

1 Avenue Z 0134

Thanks,
Jeremy

 

[JamesCanale]

Mr Excel Playground 3.xlsm
	A	B
26	40610 Dog Rd 352	40610 Dog Rd
27	205 Scott Ln 66	205 Scott Ln
28	35150 Trace St	35150 Trace St
29	70 Cut off Boulevard 6	70 Cut off Boulevard
30	1 Avenue Z 0134	1 Avenue Z
Sheet13

Cell Formulas
Range	Formula
B26:B30	B26	=LEFT(A26,LEN(A26)-COUNT(VALUE(RIGHT(A26,(SEQUENCE(LEN(A26),1,1,1))))))

 

[jeremyr863]

Mr Excel Playground 3.xlsm
	A	B
26	40610 Dog Rd 352	40610 Dog Rd
27	205 Scott Ln 66	205 Scott Ln
28	35150 Trace St	35150 Trace St
29	70 Cut off Boulevard 6	70 Cut off Boulevard
30	1 Avenue Z 0134	1 Avenue Z
Sheet13

Cell Formulas
Range	Formula
B26:B30	B26	=LEFT(A26,LEN(A26)-COUNT(VALUE(RIGHT(A26,(SEQUENCE(LEN(A26),1,1,1))))))

Beautiful. This works perfectly, thanks for helping.