I have a column of data that looks like this
A
123 hello
fffffffff
1234:gggggg
12322222222
And i want get ride of the numbers for the ones that have numbers followed by colon i have tried the find formula but for some reason i couldnt get it to work. Anybody knows how to do this?
Please help, i have go zellions of them to edit
thanks
This message was edited by benyam on 2002-10-04 15:08
This message was edited by benyam on 2002-10-04 15:14
A
123 hello
fffffffff
1234:gggggg
12322222222
And i want get ride of the numbers for the ones that have numbers followed by colon i have tried the find formula but for some reason i couldnt get it to work. Anybody knows how to do this?
Please help, i have go zellions of them to edit
thanks
This message was edited by benyam on 2002-10-04 15:08
This message was edited by benyam on 2002-10-04 15:14