Assuming your "numbers" only have one dash in them, select the cells you
want to do the replace operation on, then click Edit/Replace on the menu bar
and put -* (that is a dash followed by an asterisk) in the "Find What" field
and leave the "Replace With" field empty, then hit the "Replace All" button.

--
Rick (MVP - Excel)


"skmc" wrote in message
...
I have the following type of numbers/sqequence 1234-4567, which i want to
search for (????~-????), this works, but now i want to keep ONLY the 1st 4
numbers (i.e.) 1234 and discard the remaining (i.e.) -4567. Any help would
be
appreciated!!