Written by co-founder Kasper Langmann Microsoft Office Specialist. Microsoft Word is great for working on documentsbut not so great with tables. Here is the formula that will give us the right number of words.
Select a blank cell enter the formula TRIM REPLACE A2MIN FIND 1234567890A212345678900 A2 is the cell where you will insert space between number and text into it and press the Enter key.
Write the sentence This is my first sentence. Lets talk about the formula. Place the cursor where you want to insert the Excel worksheet. To do this click inside the last cell in the fourth column click on Layout in the ribbon and then click on Formula at the far right.