Hello, Mr. Excel. I have a question regarding how to use Macro or script in Excel. Currently, I was entering data into excel file. And
for example, in one of the cell it writes "en: Stock span" and the "en:" and "span" part repeat itself through the whole column but the "Stock" part changes every time. Is there any automated way to creat a macro or script that format the cell in form of "en:" -- ask for input data -- "span"? so it looks like "en: ___ span" and this should all be in one cell. The whole column should be formated that way until the end of the file. So the user only need to type in "Stock" part. It will be even better if it ask for that part automatically. And other easier question, what if only the "en:" repeats itself but we need to insert data after that in the same cell. Is there any way that I can type in data and format it to "en: Data" form?
Thank you very much.
Yours Elisa
for example, in one of the cell it writes "en: Stock span" and the "en:" and "span" part repeat itself through the whole column but the "Stock" part changes every time. Is there any automated way to creat a macro or script that format the cell in form of "en:" -- ask for input data -- "span"? so it looks like "en: ___ span" and this should all be in one cell. The whole column should be formated that way until the end of the file. So the user only need to type in "Stock" part. It will be even better if it ask for that part automatically. And other easier question, what if only the "en:" repeats itself but we need to insert data after that in the same cell. Is there any way that I can type in data and format it to "en: Data" form?
Thank you very much.
Yours Elisa