====================================
To get right end characters from a data in a cell, you can use "=RIGHT(cell number, number of characters)"
Example
cell "c4" got a data like "MS.Samorn Jaisuk 0988908" and you want to get last 4 characters which is "8908". You can use =Right(c4,4) then you can get 8908 show on the cell that you enter this formula.
Note: to get different number of character, you can replace 4 with other number.
Watch VDO for an example.
No comments:
Post a Comment