Have you looked at using Edit=Replace

Are the numbers 1 and 0 found in other locations in the text string?

--
Regards,
Tom Ogilvy

"SUZZI" wrote in message
...
Hi

I have data on Column a1 as:

A1

1HOTEL
0PURCHASER TOWN/
POST OFFICE
COMMUNITY
0

Data format is general

I want to remove 1,0 i am using this formaula but it does
not work for POST OFFICE & COMMUNITY

=IF(OR(MID(A1,1,1)=1,MID(A1,1,1)=0,MID(A1,1,1)="") ,A1,MID
(31,2,60))

can any one Help on this one please

Thanks