USE THE LEFT AND RIGHT FUNCTIONS TO SEPARATE A TEXT STRING OF NUMBERS USING MICROSOFT EXCEL

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.  Text Functions.

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->.

USE THE LEFT AND RIGHT FUNCTIONS TO SEPARATE A TEXT STRING OF NUMBERS USING MICROSOFT EXCEL