Another way to do it is to copy the range (a single column) to where you want
it.

Select that new column (or the old column if you can lose the original text)
Edit|Replace
what: (spacebar)* (space character followed by an asterisk)
with: (leave blank)
replace all

This will leave the leading digits--but it'll become a real number. You may
want to format it to keep any leading 0's.

Format|cells|number tab|Custom
000000




bg wrote:

Good Morning,
Is there a way to take data from the point in the cell that it contains a -
(hyphen)
for example, the length can chg but it will always be 6 numbers and then a
hypen and then the part I want (ie . Sales order 1 etc..)

123456 - Sales order 1
234567 - Sales order 15

--

Dave Peterson