![]() |
MS Excel Comment picture
Hi all, please help me
Actually my requirement is, in my excel sheet I am having style no and respective picture those pictures are in comment. Now I want to take this picture out with particular style no as the picture name Example Column A Column B 002893 Picture 234455 picture 009944 picture 990494 picture After extracting it should be 002893.jpg 234455.jpg 009944.jpg 990494.jpg |
MS Excel Comment picture
Not sure I fully understand what you require but if you enter the following
formula in say, cell C2 and copy down you will see what you want to extract: =A2&".jpg" Hope this helps "Rohan" wrote: Hi all, please help me Actually my requirement is, in my excel sheet I am having style no and respective picture those pictures are in comment. Now I want to take this picture out with particular style no as the picture name Example Column A Column B 002893 Picture 234455 picture 009944 picture 990494 picture After extracting it should be 002893.jpg 234455.jpg 009944.jpg 990494.jpg |
All times are GMT +1. The time now is 03:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com