Excel Guruji

Excel EXACT Function

When to Use the Excel EXACT Function in Excel

The EXACT function in Excel is a valuable tool when you need to compare two text strings for exact matches. It is commonly used in situations where data validation or quality control is essential, as it ensures that two text values are precisely the same, including letter case.

What Excel EXACT Function Returns

The Excel EXACT function returns the Boolean value “TRUE” if two text strings are identical and “FALSE” if they are not.

Syntax of Excel EXACT Function

The syntax of the Excel EXACT function is as follows:

=EXACT(text1, text2)

Input Arguments

Here are the input arguments for the Excel EXACT function:

👉 text1: The first text string you want to compare. It can be a cell reference containing the text or a direct text entry enclosed in quotation marks.

👉 text2: The second text string for comparison. Similar to text1, it can be a cell reference or a direct text entry enclosed in quotation marks.

Extra Notes

👉 The EXACT function is case-sensitive, meaning it distinguishes between uppercase and lowercase letters. “Excel” and “excel” would be considered different.

👉 If the two text strings match exactly, the function returns “TRUE”. If there is any difference, it returns “FALSE”.

Common Mistakes to Avoid

👉 Neglecting case sensitivity: Be mindful of the letter case when using the EXACT function. Uppercase and lowercase letters are treated as different characters.

👉 Ignoring leading and trailing spaces: Remember that spaces at the beginning or end of a text string can affect the comparison results.

👉 Mismatched data types: Ensure that both text1 and text2 have the same data type (text) for accurate comparisons.

Tips For Optimal Usage

To make the most out of the Excel EXACT function, consider the following tips:

👉 Use the EXACT function in combination with other functions like IF or COUNTIF to create custom validation rules.

👉 Leverage the TRIM function to remove leading and trailing spaces before using EXACT, ensuring accurate comparisons.

👉 Consider creating a data validation checklist using the EXACT function to maintain data integrity in your spreadsheets.

Examples of the Excel EXACT Function

Here are a couple of examples illustrating the use of the EXACT function in Excel:

Example 1: Basic Usage

Suppose you have two text strings in cells A1 and B1, and you want to check if they are identical. In cell C1, use the following formula:

The result will be “TRUE” if both text strings match exactly and “FALSE” if they differ.

Example 2: Conditional Formatting

You can use the EXACT function in conjunction with conditional formatting to highlight cells that contain matching text. For example, if you have a list of names in column A and want to highlight the names that match a specific name in cell B1:

Here are the steps on how to do it

Select the range of cells in column A where you want to apply conditional formatting. In this case, select the cells from A1 to A5. Go to “Conditional Formatting” in the toolbar (Step 1) . In the Conditional Formatting menu, select “New Rule” to create a new conditional formatting rule. (Step2)

In the “New Formatting Rule” dialog box, In select a rule type choose “Use a formula to determine which cells to format” (Step3). In the “Format values where this formula is true” field, enter the following formula (Step 4). Click the “Format” button to choose the formatting style (Step5).

The dollar signs ($) in $B$1 make sure that the comparison always references cell B1, even as you copy the formatting rule to other cells.

After selecting your desired formatting options (Step 6), click “OK” to close the “Format Cells” dialog box (Step 7)

You will now see that the names in column A that match the name in cell B1 are highlighted with the formatting you selected.

If you change the name in cell B1 to something different, the conditional formatting will automatically update to highlight the matching names in column A based on the new value in B1. This technique can be useful for visually identifying matching data in a list.

Conclusion

In summary, the Excel EXACT function is a precise tool for comparing text strings in a case-sensitive manner. Whether you’re ensuring data accuracy or validating entries, the EXACT function can be a valuable addition to your Excel toolkit.

Remember, mastering Excel functions takes practice, so don’t hesitate to experiment with the EXACT function in various scenarios to enhance your Excel skills. Start using the EXACT function today to maintain data integrity and accuracy in your spreadsheets.

Frequently Asked Questions (FAQs)

Q1: Can the EXACT function be used to compare numbers or other data types?

A1: No, the EXACT function is specifically designed for comparing text strings. It won’t work with numbers or other data types.

Q2: Does the EXACT function consider leading and trailing spaces?

A2: Yes, the EXACT function treats leading and trailing spaces as significant. Two text strings with different spaces will not be considered identical.

Q3: Can I use the EXACT function with wildcards for partial matching?

A3: No, the EXACT function only performs exact, character-by-character comparisons. If you need partial matching or pattern matching, you’ll need to use other Excel functions like FIND or SEARCH.

Other Related Excel Functions

SUBSTITUTE Function

LEFT Function

RIGHT Function

MID Function

REPLACE Function

CONCAT Function

LEN Function

UPPER Function

LOWER Function

Join me on Instagram and YouTube for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

Excel VALUE Function

When to Use the Excel VALUE Function in Excel

The VALUE function is your go-to choice when you encounter situations like:

• Importing data from external sources (e.g., CSV files) where numbers are formatted as text.
• Performing mathematical operations on data that is mistakenly stored as text.
• Cleaning up datasets with mixed data types, converting text numbers into numerical values.

In essence, if you have a number disguised as text in your Excel spreadsheet, the VALUE function can help you reveal its true numerical identity.

What Excel VALUE Function Returns

The Excel VALUE function returns a numeric value after converting a text representation of a number. It takes a single argument, which is the text you want to convert.

Syntax of Excel VALUE Function

The syntax of the Excel VALUE function is straightforward:

=VALUE(text)

Input Arguments

Here’s the input argument for the Excel VALUE function:

👉 text: This is the text value you want to convert into a number. It can be a direct text entry enclosed in quotation marks, a reference to a cell containing text, or even a formula that results in a text string.

Extra Notes

👉 If the provided text is not a valid numeric representation (e.g., contains alphabetic characters, special characters, or isn’t formatted as a number), the VALUE function will return a #VALUE! error.

👉 The VALUE function does not differentiate between various number formats (e.g., currency symbols, commas, or decimal points). It simply attempts to convert the text into a number.

Common Mistakes to Avoid

👉 Ensure that the text you’re trying to convert is indeed a valid numeric representation. Non-numeric characters or formatting issues can lead to errors.

👉 Always enclose text entries in double quotation marks when using direct text values as arguments.

👉 Be cautious when working with data imported from external sources; they often contain numeric values represented as text.

Tips For Optimal Usage

To make the most out of the Excel VALUE function, consider these tips:

👉 Use cell references whenever possible, especially when working with large datasets. This allows for easy automation and updates as data changes.

👉 Double-check the results to ensure that the conversion has been performed correctly. Sometimes, data inconsistencies can lead to unexpected outcomes.

Examples of the Excel VALUE Function

Let’s illustrate the Excel VALUE function with a couple of examples:

Example 1: Basic Usage

Suppose cell A1 contains the text “123” (as text), and you want to convert it into a numeric value. In cell B1, use the following formula:

Example 2: Handling Error with Excel IFERROR Function

Suppose you have a dataset in Column A where some cells are empty or contain text, and others have numeric values. To ensure you only convert valid numeric text, you can use the IFERROR function in combination with VALUE. In column B, enter the following formula and drag it down:

This formula attempts to convert the text in Column B into numeric values and returns an empty string (“”) if it encounters an error, such as when a cell is empty or contains non-numeric text.

Conclusion

In conclusion, the Excel VALUE function is a valuable asset in your data manipulation toolkit. It empowers you to seamlessly convert text-based numbers into actual numerical data, ensuring accurate calculations and analysis in your Excel workbooks.

Remember, mastering Excel functions takes practice, so don’t hesitate to experiment and explore different applications of the VALUE function in your projects. Start utilizing the VALUE function today and enhance your Excel skills to new heights!

Frequently Asked Questions (FAQs)

Q1: Can the VALUE function convert text into date values?

A1: No, the VALUE function is specifically designed to convert text into numeric values. To convert text into date values, you would use functions like DATEVALUE or other date-related functions.

Q2: What happens if the text contains a comma or currency symbol?

A2: The VALUE function does not consider formatting. It will attempt to convert the text into a number regardless of symbols or formatting. If the text cannot be interpreted as a number, it will result in a #VALUE! error.

Q3: Can the VALUE function handle large numbers?

A3: Yes, the VALUE function can handle large numbers, as long as the text represents a valid number within Excel’s numerical limits. Excel’s maximum number size is 1.79769313486232 x 10^308.

Q4: Is there a function to convert numbers into text?

A4: Yes, you can use the TEXT function in Excel to convert numbers into text with specific formatting. It allows you to control how numbers are displayed as text.

Other Related Excel Functions

LEN Function

UPPER Function

LOWER Function

Join me on Instagram and YouTube for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

Excel SEARCH Function

When to Use the Excel SEARCH Function in Excel

The Excel SEARCH function comes in handy when you need to determine the starting position of a specific substring within a text string. This can be immensely useful for tasks such as data extraction, conditional formatting, and more. By providing the position of the sought substring, the Excel SEARCH function enables you to precisely manipulate your data.

What Excel SEARCH Function Returns

In essence, the Excel SEARCH function returns the position of the first character of the searched substring within the given text. If the substring is not found, the function returns an error value, making it an excellent tool for validation and error checking in your worksheets.

Syntax of Excel SEARCH Function

The syntax of the Excel SEARCH function is as follows:

=SEARCH(find_text, within_text, [start_num])

Input Arguments

Let’s break down the input arguments for the Excel SEARCH function:

👉 find_text: This is the substring you want to find within the within_text. It can be a direct text entry, a cell reference, or a formula that evaluates to text.

👉 within_text: This is the text string in which you want to search for the find_text.

👉 start_num (optional): This argument lets you specify the starting position for the search within the within_text. If omitted, the search starts from the beginning. It’s especially useful when you want to find multiple occurrences of a substring.

Extra Notes

👉 If the find_text is not found within the within_text, the SEARCH function returns the #VALUE! error.

👉 The SEARCH function is case-insensitive, meaning it treats uppercase and lowercase letters as equivalent.

👉 The start_num argument cannot be negative. If it is negative or zero, the function returns an error.

Examples of the Excel SEARCH Function

Let’s explore a few examples of using the SEARCH function in Excel:

Example 1: Basic Usage

Suppose cell A1 contains the text “Excel functions are powerful.” You want to find the position of the word “functions.” In cell B1, use the formula:

Example 2: Using the start_num Argument

Let’s say you want to find the second occurrence of “functions” in cell A1. In cell B1, use the formula:

Here’s what each part of the formula does:

(1) SEARCH(“functions”, A1)

• This inner SEARCH function searches for the first occurrence of the word “functions” within the text in cell A1. Let’s say this position is 7 (counting spaces and characters).

(2) SEARCH(“functions”, A1) + 1

• This part adds 1 to the position found in step 1. In our example, it would be 8. This adjustment is made so that the search for the second occurrence starts from the character immediately after the first occurrence.

(3) SEARCH(“functions”, A1, SEARCH(“functions”, A1) + 1)

• This outer SEARCH function starts searching for the word “functions” again, but this time, it starts from the position calculated in step 2 (8). This effectively skips the first occurrence and looks for the second occurrence.

Example 3: Extracting Text Between Brackets

Suppose you have a list of product codes in column A, and the product codes are enclosed in square brackets. Your goal is to extract the product codes from within the brackets.

Let’s break down the formula step by step:

(1) SEARCH(“[“, A1)

• This part of the formula searches for the position of the opening square bracket [ within the text in cell A1.

(2) SEARCH(“]”, A1):

• This part of the formula searches for the position of the closing square bracket ] within the text in cell A1.

(3) SEARCH(“]”, A1) – SEARCH(“[“, A1) – 1

• This calculates the length of the text between the opening and closing square brackets. It subtracts the position of the opening square bracket from the position of the closing square bracket and then subtracts 1 to exclude the brackets themselves.

(4) MID(A1, SEARCH(“[“, A1) + 1, SEARCH(“]”, A1) – SEARCH(“[“, A1) – 1)

• This part of the formula uses the MID function to extract the text between the brackets. The MID function takes three arguments: the text from which to extract (A1), the starting position (found in step 1), and the number of characters to extract (calculated in step 3).

Excel Search Function – Video Tutorial

Difference Between SEARCH Function & FIND Function

Both the SEARCH and FIND functions in Excel are used to locate the position of a specific substring within a text string. However, there is a crucial difference between the two functions: case-sensitivity.

• Use SEARCH when you want a case-insensitive search. For instance, if you’re searching for the word “mango”, SEARCH will find “mango”, “Mango” and “MANGO”.
• Use FIND when you want a case-sensitive search. For example, if you’re looking for the word “mango”, FIND will only find “mango” and not “Mango” or “MANGO”.

Conclusion

In conclusion, the Excel SEARCH function is an invaluable tool for locating substrings within text strings. Whether you are cleaning up data, validating entries, or performing advanced analysis, the SEARCH function empowers you with precise control over your text data.

Remember, the true mastery of Excel functions comes from hands-on practice. So, don’t hesitate to experiment and apply the SEARCH function in various scenarios. Start using the SEARCH function today to unlock new dimensions of efficiency and accuracy in your Excel projects!

Frequently Asked Questions (FAQs)

Q1: Can the SEARCH function be used for case-sensitive searches?

A1: No, the SEARCH function is case-insensitive and treats uppercase and lowercase letters as the same.

Q2: What does the SEARCH function return if the find_text is not found?

A2: If the find_text is not found, the SEARCH function returns the #VALUE! error.

Q3: Can the start_num be a negative value?

A3: No, the start_num must be a positive integer. Negative values will result in an error.

Q4: Can the SEARCH function be used for finding multiple occurrences of a substring?

A4: Yes, by adjusting the start_num argument, you can find multiple occurrences of a substring within the within_text.

Q5: Is there a way to perform case-sensitive searches in Excel?

A5: Yes, for case-sensitive searches, you can use the FIND function instead of SEARCH.

Other Related Excel Functions

LEN Function

UPPER Function

LOWER Function

Join me on Instagram and YouTube for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

Excel SUBSTITUTE Function

When to Use the Excel SUBSTITUTE Function in Excel

The SUBSTITUTE function in Excel is your go-to tool when you need to replace specific instances of text within a larger text string. This function proves invaluable in scenarios where you want to make selective changes, remove unwanted characters, or update outdated information.

What Excel SUBSTITUTE Function Returns

The Excel SUBSTITUTE function replaces occurrences of a specified old text with new text in a given text string. You have the freedom to decide how many instances you want to replace. This makes it perfect for tasks such as standardizing data or correcting consistent typos.

Syntax of Excel SUBSTITUTE Function

The syntax of the Excel SUBSTITUTE function is as follows:

=SUBSTITUTE(text, old_text, new_text, [instance_num])

Input Arguments

Here are the input arguments for the Excel SUBSTITUTE function:

👉 text: The text string that contains the instances you want to replace. This can be a direct text entry, a cell reference containing text, or a formula resulting in text.

👉 old_text: The specific text you want to replace within the text argument.

👉 new_text: The text you want to substitute in place of old_text.

👉 instance_num (optional): This parameter allows you to specify which occurrence of old_text you want to replace. If omitted, all instances of old_text will be replaced.

Extra Notes

👉 If old_text is not found within the text string, no changes will occur.

👉 If you provide an instance_num that is greater than the number of occurrences of old_text, no replacement will occur.

👉 The SUBSTITUTE function is case-sensitive. “Apple” and “apple” are treated as distinct text.

Common Mistakes to Avoid

👉 Misplacing quotation marks: Ensure that you properly enclose your text entries, old and new, in double quotation marks.

👉 Omitting the new_text argument: Every instance of old_text needs a corresponding replacement defined in new_text.

👉 Incorrect instance_num: If you want to replace a specific occurrence, make sure to count correctly and provide the appropriate instance number.

Tips For Optimal Usage

To make the most of the SUBSTITUTE function, consider these tips:

👉 Combine SUBSTITUTE with other functions like FIND or LEN for more intricate text manipulations.

👉 Experiment with relative and absolute cell references to automate replacements across multiple cells.

👉 Always double-check your new_text to avoid inadvertently changing data.

Examples of the Excel SUBSTITUTE Function

Let’s walk through a few examples to demonstrate the prowess of the Excel SUBSTITUTE function.

Example 1: Basic Usage

Suppose you have a list of product names containing “pro” that you want to change to “professional”. In cell B1, input:

Remember, The “Find and Replace” option is great for quick and simple text replacements, if you need to perform more intricate replacements or apply conditional transformations, using functions like SUBSTITUTE allows you to craft more dynamic and versatile solutions.

Example 2: Removing Unwanted Characters

In a list of product codes, there are unnecessary underscores. You want to remove all underscores from the codes.

Example 3: Replacing Multiple Special Characters

Suppose you have a text string that contains special characters like !, @, #,$ and you want to replace all of them with a space.

Here’s the breakdown of the formula:

(1) SUBSTITUTE(A1, “!”, ” “)

• This innermost SUBSTITUTE function replaces all occurrences of the exclamation mark “!” in cell A1 with a space ” “. The result is a text string with exclamation marks replaced by spaces.

(2) SUBSTITUTE(result_1, “@”, ” “)

• The result from the previous step (result_1) is then further processed by the next SUBSTITUTE function. It replaces all occurrences of the at symbol “@” with a space ” “. This continues the process of replacing characters with spaces.

(3) SUBSTITUTE(result_2, “#”, ” “)

• The result from the previous step (result_2) is further processed to replace all occurrences of the hash symbol “#” with a space ” “.

(4) SUBSTITUTE(result_3, “$”, ” “)

• The result from the previous step (result_3) is once again processed to replace all occurrences of the dollar sign “$” with a space ” “.

(5) TRIM(result_4)

• Finally, the TRIM function is applied to the result from the last SUBSTITUTE operation (result_4). The TRIM function removes any leading or trailing spaces and ensures that there is only a single space between words.

The SUBSTITUTE function doesn’t support replacing multiple characters simultaneously using an array constant [like =SUBSTITUTE(A1, {“!”,”@”,”#”,”$”}, ” “)]

If you want to replace multiple special characters with a single SUBSTITUTE function, you would need to nest SUBSTITUTE functions as shown in the earlier examples.

Example 4: Replacing Specific Occurrences

You have a text string “A A A A A” and want to replace the fourth occurrence of “A” with “a”. In cell B1, input:

Conclusion

The Excel SUBSTITUTE function empowers you to manipulate text efficiently, giving you the ability to make precise replacements within text strings. By mastering this function, you open the door to a world of data cleaning, transformation, and consistency. With practice and creativity, you will uncover its potential to elevate your Excel skills to new heights.

Feel free to experiment, refine, and integrate SUBSTITUTE into your own projects. Excel is a toolbox, and SUBSTITUTE is a powerful tool that can help you achieve remarkable text transformations with ease.

Frequently Asked Questions (FAQs)

Q1: Can SUBSTITUTE handle case-insensitive replacements?

A1: No, SUBSTITUTE is case-sensitive. “Apple” and “apple” are treated differently.

Q2: What if old_text appears multiple times within text but I want to replace only the third occurrence?

A2: You can achieve this by specifying instance_num as 3 in your SUBSTITUTE formula.

Q3: Can I use cell references for old_text and new_text?

A3: Yes, you can use cell references as long as they contain the appropriate text values.

Q4: Does SUBSTITUTE work with numbers as well?

A4: Yes, SUBSTITUTE can replace numbers just like text, as long as you treat them as text entries.

Other Related Excel Functions

RIGHT Function

LEN Function

UPPER Function

LOWER Function

Join me on Instagram and YouTube for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

Excel TRIM Function

When to Use the TRIM Function in Excel

The TRIM function comes to the rescue when you are dealing with text strings that have unnecessary leading or trailing spaces. These spaces can throw a wrench in your data analysis, causing issues when trying to match or compare values.

What Excel TRIM Function Returns

In essence, the Excel TRIM function does just one thing – it removes any extra spaces from a text string, leaving only a single space between words and no leading or trailing spaces.

Syntax of Excel TRIM Function

The syntax of the Excel TRIM function is quite straightforward:

=TRIM(text)

Input Arguments

Here are the input arguments for the Excel TRIM function:

👉 text: This is the text string that you want to trim. It can be a direct text entry, a cell reference containing text, or a formula that evaluates to a text string.

Extra Notes

👉 The TRIM function doesn’t affect spaces between words, ensuring your text remains coherent.

👉 If your text contains non-breaking spaces (CHAR(160)), TRIM won’t remove those. You might need to use SUBSTITUTE or another approach to deal with them.

Common Mistakes to Avoid

👉 Misapplying TRIM: Remember, TRIM only removes leading and trailing spaces. If you have extra spaces between words that you want to reduce to a single space, you might need to combine TRIM with other functions.

👉 Overusing TRIM: While TRIM is a lifesaver for cleaning up data, don’t overdo it. Applying TRIM to cells that don’t have extra spaces can slow down your calculations unnecessarily.

👉 Neglecting Non-Breaking Spaces: Keep in mind that TRIM doesn’t remove non-breaking spaces (CHAR(160)) which might exist in your text.

Tips For Optimal Usage

For a smooth experience with the Excel TRIM function, keep these tips in mind:

👉 Combine with FIND or SEARCH: If you need to remove specific characters along with spaces, consider combining TRIM with the FIND or SEARCH functions to locate those characters.

👉 Use on Imported Data: When you import data from external sources, extra spaces can often sneak in. Apply TRIM after importing to ensure clean data.

👉 Utilize on Concatenated Data: If you’re concatenating text strings from different sources, spaces can creep in. TRIM will help maintain the integrity of your concatenated results.

Examples of the TRIM Function in Excel

Let’s look at a couple of examples to see how the TRIM function works:

Example 1: Basic Usage

Suppose cell A1 contains the text ” Excel TRIM Function ” with extra spaces. You can use the following formula in cell B1:

Example 2: Extracting Initials from Full Names

Suppose you have a list of full names in column A (e.g., “Samuel Johnson”) and you want to extract the initials from each name. You can use TRIM in combination with LEFT and MID functions

Here’s the breakdown of the formula:

(1) TRIM(A1)

• The TRIM function is applied to the text in cell A1 to remove any leading or trailing spaces.

(2) LEFT(TRIM(A1), 1)

• The LEFT function extracts the first character of the trimmed text (the first initial).

(3) “.”

• A period is concatenated to the first initial using the ampersand (&) operator.

(4) MID(TRIM(A1), FIND(” “, TRIM(A1), 1) + 1, 1)

• The MID function extracts a portion of the trimmed text. The FIND function is used to locate the position of the first space within the trimmed text. Adding 1 to this position gives the starting position of the second word (second initial). The MID function then extracts 1 character from this position.

Conclusion

The Excel TRIM function might not be the flashiest function, but it is a true workhorse when it comes to maintaining clean and consistent text data. By eradicating unwanted spaces, TRIM ensures that your analyses and calculations are accurate and error-free.

Remember, just like any Excel function, the more you use TRIM, the more comfortable you’ll become with it. Incorporate it into your data cleaning routine, and you’ll soon wonder how you ever managed without it. Happy trimming!

Frequently Asked Questions (FAQs)

Q1: Does the TRIM function affect spaces between words?

A1: No, the TRIM function only removes leading and trailing spaces. It ensures that there’s only one space between words in the text. Internal spaces within the text remain unchanged..

Q2: Can the TRIM function be used on numeric values?

A2: No, the TRIM function is designed specifically for text values. Applying it to numeric values or other non-text entries will have no effect.

Q3: Can I use TRIM in combination with other text functions?

A3: Absolutely! TRIM can be a powerful component of more complex text manipulation formulas. It’s often used in combination with other functions like SUBSTITUTE, CONCATENATE (or the “&” operator), FIND, and MID to achieve specific text cleaning or transformation tasks.

Q4: Does the TRIM function have any impact on formulas that reference the trimmed cell?

A4: Yes, using TRIM on a cell will modify the text within that cell. If you have formulas referencing the original cell, they will now reference the trimmed text. Keep this in mind if you have downstream formulas relying on the untrimmed text.

Q5: Can TRIM be applied to a range of cells?

A5: Yes, you can apply the TRIM function to a range of cells using array formulas. For example, if you have a range of text in cells A1:A10, you can enter the formula =TRIM(A1:A10) as an array formula by pressing Ctrl+Shift+Enter instead of just Enter.

Other Related Excel Functions

RIGHT Function

LEN Function

UPPER Function

LOWER Function

Join me on Instagram and YouTube for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!