A worksheet contains a list of 10-digit numbers that have to be separated into two parts: a three-digit part and a seven-digit part. Use the LEFT and RIGHT functions to do this. The LEFT function returns the first character or characters in a text string, based on the number of characters specified. The RIGHT function returns the last character or characters in a text string based on the number of characters specified.
To separate a text string of numbers:
1. In a worksheet, enter a series of 10-character numbers in cells A2:A10. The numbers can also contain letters.
2. Select cells B2:B10 and type the following formula: =LEFT(A2,3).
3. Press <-Ctrl+Enter->.
4. Select cells C2:C10 and type the following formula: =RIGHT(A2,7).
5. Press <-Ctrl+Enter->.
Watch the Video Tutorial - https://www.youtube.com/watch?v=Ht4F4HDnIeQ
Hope You Like This Tutorial - Give Comments
No comments:
Post a Comment