Excel - Cutting left characters

Excel - Cutting left characters

====================================

To cut left characters from a data in a cell, you can use "=RIGHT(cell number,(Len(cell number)-number of characters))"

Example

cell "c5" got a data like "Mr.Somsak Sukjai " and you want to cut 3 characters from left end, which is "Mr.". You can use =Right(c5,(Len(c5)-3)) then you can cut off  "Mr." and the result will show on the cell that you enter this formula.

Note: to get different number of character, you can replace 3 with other number.

Watch VDO for an example.