MS Excel Comment picture

R

Rohan

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
 
R

Ron@Buy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top