Here are the steps to add a full stop between the fourth and fifth character of a six-character string in Microsoft Excel:
- Select the cell that contains the text string you want to modify.
- Click on the formula bar at the top of the screen to activate it.
- Use the formula
Code:
=LEFT(A1,4)&"."&RIGHT(A1,2)
to insert a full stop between the fourth and fifth character of the text string. (Note: Replace "A1" with the cell reference of the cell containing the text string you want to modify.) - Press Enter to apply the formula to the cell.
- The modified text string with the full stop in the middle should now appear in the cell.
That's it! You have successfully added a full stop between the fourth and fifth character of a six-character string in Microsoft Excel.