Welcome Guest.

4Answers

How to extract a string of numbers in the WPS form

Asked by: Kenneth 172 views Software April 19, 2019

How to extract a string of numbers in the WPS form

4 Answers

  1. +4Votes  

    C1 cell input formula = RIGHT(B1,5), then pull down.

    John Thompson- April 20, 2019 |

  2. +6Votes  

    Assume that the data is in the a1 cell at b1 input=REPLACE(REPLACE(A1,3,3,"张"), 4,2,"Li") dropdown

    Michael- April 20, 2019 |

  3. +7Votes  

        To set up a code is fine. Now you can set it directly…············

    Helen Walker- April 20, 2019 |

  4. +4Votes  

    Use the right function. Let this string be in cell A1, the formula is: =right(a1,5) Baidu knows

    Pamela Williams- April 21, 2019 |