Hi

If you just want text then if a2 = 1* then LEFT(A2,Len(A2)-1) returns 1 as
text.

To convert "1" to a number, and ignore text "w" use

=IF(ISNUMBER(LEFT($A2,LEN($A2)-1)*1),LEFT(A2,LEN(A2)-1)*1,LEFT(A2,LEN(A2)-1))

Regards
Peter
" wrote:

Hi, Is there way to looking in a column for a number or number +
wildard, and replacing it with just a number?

for example, suppose you have a list of number(s) or letter(s) with or
without wildcards

like this: on Column "D"
1*
2*
3*
w*

you like to just remove the astricks (*) with just the number or
letter. by using Vlookup into another cell for example in Cell "A5",
but not replacing the actaully column that has the data.

can this be done? i really appericated the help, thanks a bunch,..