| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, how do I set up default comment containing picture? | Excel Discussion (Misc queries) | |||
| insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
| How do I insert a picture within an Excel comment box? | Excel Discussion (Misc queries) | |||
| How do I insert a picture in an Excel comment block | Excel Worksheet Functions | |||
| EXCEL: Is there a way to insert a picture into a comment? | Excel Worksheet Functions | |||
Linear Mode
