EDIT
Edits the values in a range according to the user's instructions
The Edit Smart Function is a versatile tool that enhances your spreadsheet capabilities by allowing you to modify cell values in a specified range based on your guidelines. Whether you need data cleaning, text formatting, or quick value updates, EDIT_X has you covered. It's an all-in-one solution for tasks ranging from simple data adjustments to complex spreadsheet management, making it indispensable for professionals across various fields.
Examples
=EDIT_X(A1, "Reverse text")

Output Example: txet desreveR
=EDIT_X(A1:A5, "Convert all full names to initials (e.g., 'John Smith' to 'J.S.')")

Output Example:
J.S.
S.J.
T.L.
A.P.
S.J.
=EDIT_X(Sheet1!D8,"Convert measurements from the imperial system (popular in the US) to the metric system (popular in the EU) and modify the text according to European culture",{"act_like","Professional Adaptation Specialist";"extra_instructions","Remember, that USD → EUR exchange rate is " & GOOGLEFINANCE("Currency:USDEUR")})

Output Example:
This fantastic product weighs just 2.27 kilograms and costs €46.09! Perfect for the European lifestyle, it operates at 23.89°C and can be shipped all over the European Union.
=EDIT_X(B4,"Insert the SEO keywords naturally into the text. List of keywords: " & TEXTJOIN(", ",TRUE,'Key Words'!A1:A5),{"temperature",10;"act_like","SEO Specialist";"extra_instructions","Maintain the original tone and context; Use each keyword at least once"})

Output Example:
Learn how to bake the best Homemade cookies with our easy-to-follow Baking tips. Our Cookie recipe will make you the star of any gathering. From selecting the right ingredients to mastering the perfect bake time, we've got you covered. Whether you're a beginner or a seasoned baker, our step-by-step instructions will help you create Delicious desserts that are not just delicious but also picture-perfect. So grab your mixing bowls and get ready to impress your friends and family with your newfound Easy baking skills.
Arguments List
=EDIT_X(range, instructions, [options])
=EDIT_Y(range, instructions, [options])
range
Range whose cell values will be changed according to instructions.
For example: A2, A1:A4, or A2:B4
instructions
Describe what you would like to change for cells in the range.
For example: "Make text two times shorter", A2 or "Copy the style of this message: " & B2
Options List
Particular object at the end of a formula which contains optional parameters values in the form {"parameter_name",value; "next_parameter_name",value}
For Example: {"extra_instructions","Remember this info: " & A1; "act_like","English Teacher"}
temperature
Adjust the deviation from deterministic answers from 0 (default, high-confidence) to 1 (greater diversity). In other words, it's the AI's creativity for the answer.
For Example: 0, 0.4, or 1
act_like
Specify a role, profession, or perspective for the AI to adopt when editing cells' value; this parameter guides the AI in providing more context-specific or specialized editing.
For example: "UX Designer", "Data Analyst", or "Professional Writer"
extra_instructions
Provide additional information or instructions to get a better result.
For example: "Rember about using the metric system", "Also, fix grammar", or "Remember this: " & B2
model
Model affects quality, speed, and tokens count of tokens to use. We choose the optimal model ("default") by default, and here it's gpt-3.5-turbo. Information about models.
Options: "default", "gpt-4, "gpt-3.5-turbo", or "gpt-3.5-turbo-16k"
max_tokens
Limit the number of tokens that can be used for one function run. By default, it's limited only by the model.
1 token ≈ 4 chars in English
1 token ≈ 3/4 words
100 tokens ≈ 75 words
1-2 sentences ≈ 30 tokens
1 paragraph ≈ 100 tokens
1,500 words ≈ 2048 tokens
For Example: 100, 350, or 2048
Websheet AI is designed to empower you in crafting the perfect website effortlessly. Discover the myriad of options and bring your vision to life.