Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mid or Right
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 |