replace "?" character

[donnIeDorian]

I ' m trying but I doesnt recongise it

=SUBSTITUTE(A2,"?"," ",)

from this text

12m YELLOW ?????aa2

[Neil_]

? is a wildcard character
=SUBSTITUTE(A2,CHAR(63)," ")

https://support.office.com/en-gb/art...rs=en-GB&ad=GB

Edit: Forget above post. Red Herring. You needed to omit the last comma as instance number is optional.

=SUBSTITUTE(A2,"?"," ")

[AliGW]

Try y=this:

=SUBSTITUTE(A2,CHAR(63),"")

[Andy Pope]

Either include an instance value or remove the last comma

=SUBSTITUTE(A2,"?"," ")

I don't think SUBSTITUTE recognises wildcards, like some other formulas do. ? and CHAR(63) would be the same thing.

[Kramxel]

try this:

Please Login or Register  to view this content.

[donnIeDorian]

Thank you all

char 63 dit it

oh and I also had one comma to many

[AliGW]

You're welcome!