| To enter 3 characters separated by a space, make a cell function to enter them in row order at B2 cell, assuming that row A is the cell containing the original name.
To populate the row B with the separated characters, make a cell function for B2 cell.
Enter "=MID(A2,1,1)&" "&MID(A2,2,1)&" "&MID(A2,3,1)" in B2 cell.
When completed, check the separated characters of the original name.
Then click the B2 cell and drag it down to the cells below it with holding the right bottom corner of the B2 cell. |
