Excel Formulas

Learn how to use Excel formulas effectively with cobby for product data management, text manipulation, lookups, and optimization.

Getting Started

Essential setup for using formulas in cobby

• Use Formulas in cobby
• Disable Data Validation
• Use Macros with cobby

Text Functions

Create and manipulate product text

• Extract Text (SEARCH, LEFT, RIGHT)
• Combine Text (CONCATENATE)
• Conditional Text (IF)
• Handle Empty Values (IFISEMPTY)
• Convert Text/Numbers (VALUE, TEXT)
• Randomize Text for SEO

Lookup Functions

Match and import data from external sources

• VLOOKUP for Data Assignment
• INDEX-MATCH for Flexible Lookups

Excel Features & Optimization

Advanced Excel features and performance tips

• Use AutoFilter
• Conditional Formatting
• Search and Fix Formulas
• Optimize Formula Performance
• Move Worksheets