Create MULTIPLE Formula Columns with Copilot in Excel (SINGLE Copilot Prompt)

Published: 01 June 2024
on channel: Computergaga
1,675
45

Create multiple formula columns in Excel with a single Copilot prompt.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

In this video the following prompt is used to split a column into four. A formula is used for each column, ensuring that they automatically update.

'Create a formula to extract the characters from the SKU column into four different columns. Extract the first three characters to a column named Product, characters 4 to 6 to a column named Serial Number, characters 7 to 9 to a column named Colour, and the last two characters to a column named Edition.'

👩🏻‍🤝‍👨🏿Connect with us!
LinkedIn ►   / alanmurray-computergaga  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1  

#copilot #excel #excelshorts


Watch video Create MULTIPLE Formula Columns with Copilot in Excel (SINGLE Copilot Prompt) online without registration, duration hours minute second in high quality. This video was added by user Computergaga 01 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,67 once and liked it 4 people.