Pages

Saturday, March 26, 2011

Use the LEFT and RIGHT functions to separate a text string of numbers - Text Functions - Microsoft Excel Tutorials


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

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews