View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Yaseen Al-Lawati[_2_] Yaseen Al-Lawati[_2_] is offline
external usenet poster
 
Posts: 8
Default to add a word between 2 words in all cells

I have a portfolio which has hundreds of diffrent identification.
in each sell I have for exapmple: USxxxxxxx corp
I want to enter in each of the cells the word ISIN between them.
so it would look like this USxxxxxxx ISIN Corp can I do that if I can't,
could I just delete the word corp from each cell by entering a formula in a
diffrent cell??