getting text

  1. R

    NEED HELP for getting text from cell

    Hi, I need your help to get some text right before some common text in the cell. E.g. if Cell A1 contains ABCD 36 IN Cell A2 contains ABCDEFGH 48 IN XX Cell A3 contains ABCD XX XXX 22 IN HHH I need that value before the IN i.e. Cell B1 it should be 36 Cell B2 it should be 48 Cell B3 it...

Some videos you may like

This Week's Hot Topics