Remove characters convert text to numbers

abujouz86  In that case you can try this: 

Column =
VAR CurrentCategory = Abu[Category]
VAR AllAlphabets =
    SELECTCOLUMNS (
        ADDCOLUMNS (
            GENERATESERIES ( 65, 90, 1 ),
            "Alphabets", LOWER ( UNICHAR ( [Value] ) )
        ),
        "Alphabets", [Alphabets]
    )
VAR RemovePeople =
    IF (
        CONTAINSSTRING ( CurrentCategory, "people" ),
        SUBSTITUTE ( CurrentCategory, " people", "" ),
        IF (
            CONTAINSSTRING ( CurrentCategory, "person" ),
            SUBSTITUTE ( CurrentCategory, " person", "" )
        )
    )
VAR SlashPostion =
    SEARCH ( "/", RemovePeople, 1, 0 )
VAR Result =
    IF (
        SlashPostion > 0,
        VAR LeftValue =
            MID ( RemovePeople, 1, SlashPostion - 1 )
        VAR RightValue =
            MID ( RemovePeople, SlashPostion + 1, LEN ( RemovePeople ) - SlashPostion )
        VAR Result =
            INT ( LeftValue ) + INT ( RightValue )
        RETURN
            Result,
        INT ( RemovePeople )
    )
RETURN
    Result