Split the Number

[S.H.A.D.O.]

Hi Everyone,

I have a List in the Format :-

Excalibur2
Excalibur3
Excalibur1
Excalibur4


What I would like to do is to get it to Show as ...

Excalibur 2
Excalibur 3
Excalibur 1
Excalibur 4

... so the Number at the End is NOT Attached to the Name Please.

All the Best.
SHADO

 

[barry houdini]

If you always have a single digit

=REPLACE(A1,LEN(A1),0," ")

if there may be a variable number of digits, possibly none

=TRIM(REPLACE(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&1234567890)),0," "))

edited formula

 

[S.H.A.D.O.]

Brilliant Barry, Thank You VERY Much.

Have a Great Weekend.
All the Best.
SHADO

 

[barry houdini]

No problem

Note that I edited the second formula because if there were no digits my first formula would have added a space at the end, the additional TRIM function removes that