ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS Excel Comment picture (https://www.excelbanter.com/excel-discussion-misc-queries/245505-ms-excel-comment-picture.html)

Rohan

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



Ron@Buy

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