In Excel, when the count and percentage are together in one cell, you cannot directly analyze them. You will need to separate them into different cells first for further analysis.

**1. To separate the count from the cell**

If there is a space between the number and the percentage, please use the formula below. If there is another special character instead of space, please change the space within the citation sign to the special character.

=LEFT(B2,FIND(" ",B2)-1)

Where B2 is the cell with the number and percentage together.

**2. To separate the percentage from the cell**

If the percentage in the cell comes with the parentheses, you can check how to extract data between parentheses, or use the formula below.

If the percentage comes with other special characters, please change "(" and ")" with the special characters.

=MID(B2,FIND("(",B2)+1,FIND(")",B2)-FIND("(",B2)-1)

Where B2 is the cell with number and percentage together.

If you want to work in the opposite way, please check how to combine the number and percentage together into one cell.

Hi All,

Please let me know ,how to Separate Number and Percentage from One Cell Eg.16.00(4.211%)?

Note: There is no space between Number and Percentage.

Please help.

please refer to the post "How to Extract Data between Brackets", here is the link: https://excelnotes.com/how-to-extract-data-between-brackets/, thank you!

Hi David,

Thanks for your response.

Sorry I not understanding.

If possible can you write the formula for my questions.

Eg.16.00(4.211%)?

Note: There is no space between Number and Percentage.

Please help.

Hello Arun, if I understand correctly, you want to separate 16.00 from 16.00(4.211%) in a column, and 4.211% from 16.00(4.211%) in another column, correct? If that is the question, please try the following formulas:

To separate the number of 16.00, try =LEFT(A1,FIND("(",A1)-1)

To separate the percentage 4.211%, try =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

Please remember to change all A1 in the formula with your first cell with data, hope this helps. In case you need different results, please let us know, thank you for visiting us.