Try
=MID(A1,FIND("-",A1)+2,LEN(A1))
where A1 has the original data. This assumes that there is indeed a
"-" character in the string.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
On Fri, 28 Aug 2009 08:49:01 -0700, 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