View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ksenija Ksenija is offline
external usenet poster
 
Posts: 19
Default how to choose a part of the text in a cell???

Can someone help me? If I have a text saying "AAAAA_BBBBB" in a cell, how can
I write a code that copies the text in front of "_" and pastes it in a cell
above????

So I have "AAAAA_BBBBB" and want to have AAAAA pasted in a cell above..