Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel.

I have a list of pictures that I took with information about each one. I’m used to focal lengths being listed as the 35mm equivalent and my camera is using a crop sensor which would change the number.

Table of Picture including columns for (file) Name, Date, Type, Size, Focal length, Fstop, and Exposure time.

I ask Copilot:

These pictures were taken on a Fuji XT2, please add a column for the 35mm equivalent focal length

Copilot in Excel pane with the above prompt and the suggested formula column formula to be applied that is described below.

Looking at B2:H46, here’s 1 formula column to review and insert in Column I:

Converts the focal length of each image to its 35mm equivalent by extracting the focal length value, converting it to an integer, and then multiplying by 1.5 (conversion factor).

=INT(INDEX(TEXTSPLIT([@[Focal Iength]], ” “,, TRUE), 1, 1)) * 1.5

After previewing the results, I click on the insert column button and the formula is added to the table:

Table of Picture including columns for (file) Name, Date, Type, Size, Focal length, Fstop, Exposure time, and new 35mm equivalent Focal length.

Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.

Thanks for reading,

Microsoft Excel Team

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.

​Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel.
 
I have a list of pictures that I took with information about each one. I’m used to focal lengths being listed as the 35mm equivalent and my camera is using a crop sensor which would change the number.
 
Table of Picture including columns for (file) Name, Date, Type, Size, Focal length, Fstop, and Exposure time.
 
I ask Copilot:
 
These pictures were taken on a Fuji XT2, please add a column for the 35mm equivalent focal length
 
Copilot in Excel pane with the above prompt and the suggested formula column formula to be applied that is described below.
 
Looking at B2:H46, here’s 1 formula column to review and insert in Column I:
Converts the focal length of each image to its 35mm equivalent by extracting the focal length value, converting it to an integer, and then multiplying by 1.5 (conversion factor).
=INT(INDEX(TEXTSPLIT([@[Focal Iength]], ” “,, TRUE), 1, 1)) * 1.5
 
After previewing the results, I click on the insert column button and the formula is added to the table:
 
Table of Picture including columns for (file) Name, Date, Type, Size, Focal length, Fstop, Exposure time, and new 35mm equivalent Focal length.
 
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
 
Thanks for reading,
Microsoft Excel Team
 
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.  Read More

​