remove space and hyphen from number

[althea]

I have 225 333-3333 in a cell and I need only numbers. What is the easiest way to remove the space and hyphen?

Thanks!!

 

[SkipVought]

Hi,

Select the column and use Edit > Replace.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[althea]

I have 40,000 of them....

 

[gizmo1973]

If you use replace all and it will remove them all no matter how many you have

Regards, Phil.

http://www.manchester-medical-services.co.uk

 

[SkipVought]

40,000 what? It's 2 operations for the shebang!

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[althea]

I got it, thanks for all of your help!!! you guys are awesome!

 

[gizmo1973]

[offtopic] shebang, now there's a word I've not seen or heard of in a while [/offtopic]

Regards, Phil.

http://www.manchester-medical-services.co.uk

 

[SkipVought]

It goes along with shezam!

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[SkipVought]

...and here's a reference at random.

http://www.randomhouse.com/wotd/index.pperl?date=20000203.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[onedtent]

couldn't find shezam or shazam anywhere

 

[Zathras]

See

http://members.ozemail.com.au/~scunge/shazam/#acronym

 

[SkipVought]

"Shazam, Sgt Carter!"

http://en.wikipedia.org/wiki/Gomer_Pyle

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}