Mid or Right
And if you are using 2007 you may have very long text entries in the cell, in
which case
=MID(C6,9,9^9)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"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
|