If your number is in A2, try this in a blank column:

=LEFT(A2,5)

which will return the values as text - if you want them as numbers, try
this:

=VALUE(LEFT(A2,5))

Copy the formula down for as many rows as you have data in column A.

Hope this helps.

Pete


RISXRAY wrote:
I formated the "-" in the cell by using custom formating (0000-00000), so
when I do the delimiting, it doesn't show the "-". My orginal number is
whole 123456789.

"Toppers" wrote:

Insert column to right of the column containing your data

Data==Text-to-Columns=Delimited=Other ..enter "-" (no quotes) then Finish.

Delete redundant data i.e one containing the 4 digits.

HTH

"RISXRAY" wrote:

Example...

1234-56789 becomes 56789