You could use Data | Text to Column
OR
If the numbers always 4 digits
=--LEFT(A1,4)
OR
=--LEFT(A1,FIND(" ",A1)-1) for variable length numbers
The double negation turns text to numbers
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Cynthia" wrote in message
...
I am using Excel 2003

I have files that display like this:

1234 Main St 3
4456 Elm St 1154
2711 Maple St 27G

I need to identify these freestanding numbers with a "comma space" in
front
of them so I can split this text into the next column. Is there a way to
do
this using CTRL-H?

Thanks in advance!
--
Cynthia