One Race Percent in Clymer, PA. At the time of the last census survey, the number of people of one race in Clymer, PA was 1,545. White Population in Clymer, PA. The estimated White population in the Clymer community is 1,540, which is 99.5 percent of the total population (The U.S. average is 75.10%).
Highlight or select a range of cells. Right-click on the highlighted cells and select Format Cells.... Click the Alignment tab and place a checkmark in the checkbox labeled Merge cells. To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar. Again, this will only preserve the text in the upper-leftmost cell. Highlight or select a range of cells.
1 In your worksheet, select the text cells you want to combine and click the Merge Cells icon. 2  In the Merge Cells dialog box, set the parameters as follows:  3  Merge selected cells  field: row by row. 4  Separate values with  field: select Other option, then enter a comma and press Alt+Enter in the edit box.ou want to have the clients' addresses in one cell separated with a comma and a line break. 1  In your worksheet, select the text cells you want to combine and click the Merge Cells icon. 2  In the Merge Cells dialog box, set the parameters as follows:  3  Merge selected cells  field: row by row.