how can I choose part of the text in a cell and paste it elsewhere

K

Ksenija

Hi,

I have a cell with text : "AAAA_BBBBB" and I would like to have a code that
copies the text in front of "_" and pastes it in the cell above.

Can someone tell me how to do this??

Thanks!
 
Top