=right(A2,len(A2)-find("- ",A2))

Added a space at the end of the find to ensure you start with the alpha.

"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