Excel question

[Pinkyhello]

Hello, is there a way to convert A below into B?

the figures in B are obtained by the items in A multiplied with the %

thanks

 

[etaf]

can you use a table to show the name and % - OR will it always be a list of names in 1 cell and % - exactly as you have shown

Also are you still using 2016 version of excel

 

[Pinkyhello]

can you use a table to show the name and % - OR will it always be a list of names in 1 cell and % - exactly as you have shown

Also are you still using 2016 version of ex

yes still using version 2016 excel

in the info i obtained it will always be a list of names in 1 cell and %', is there a quick way to show the names in separate lines with % in separate cell?

thanks