View Single Post
  #2   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



"Yaseen Al-Lawati" wrote:

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??

i solved it no need for reply
thanks