Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
to add a word between 2 words in all cells
When posting a question that you find a solution to on your own later on,
you should post that solution and then check back into the thread later on. It is possible that a better solution to the one you came up with exist and you might find it useful to see what (if any) they are (for possible future use). Doing so would also be useful for those with a similar problem who have not figured out how to do solve it (I'm thinking of those who come upon your thread in the Google archives down the line). Rick "Yaseen Al-Lawati" wrote in message ... "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
to add a word between 2 words in all cells
Hi Rick,
Great Point!! Cheers, Shane Devenshire Microsoft Excel MVP Join http://setiathome.berkeley.edu/ and download a free screensaver and help search for life beyond earth. "Rick Rothstein (MVP - VB)" wrote in message ... When posting a question that you find a solution to on your own later on, you should post that solution and then check back into the thread later on. It is possible that a better solution to the one you came up with exist and you might find it useful to see what (if any) they are (for possible future use). Doing so would also be useful for those with a similar problem who have not figured out how to do solve it (I'm thinking of those who come upon your thread in the Google archives down the line). Rick "Yaseen Al-Lawati" wrote in message ... "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I highlight a single word or group of words? | Excel Discussion (Misc queries) | |||
Can excel underline misspelled words like Word? | Excel Discussion (Misc queries) | |||
I type same words and it will not automatically repeat the word | Excel Discussion (Misc queries) | |||
Word Formating & Words Adding | Excel Discussion (Misc queries) | |||
Separate last word in cell with more than 2 words? | Excel Worksheet Functions |