Reverse Text String (Without VBA) Using Formula or With VBA Using StrReverse Function | Mirror Text
Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/02/Reverse-Text.zip
In this Microsoft Excel video tutorial I demonstrate two methods for reversing or mirroring text. The first method uses a formula, utilising the following worksheet functions: LEN, SEQUENCE, MID and CONCAT. The second method uses the StrReverse VBA function.
Table of Contents:
00:00 - Introduction
00:16 - Formula method using LEN, SEQUENCE, MID and CONCAT
02:09 - VBA method using the StrReverse function
------------------------
Видео Reverse Text String (Without VBA) Using Formula or With VBA Using StrReverse Function | Mirror Text канала Chester Tugwell
In this Microsoft Excel video tutorial I demonstrate two methods for reversing or mirroring text. The first method uses a formula, utilising the following worksheet functions: LEN, SEQUENCE, MID and CONCAT. The second method uses the StrReverse VBA function.
Table of Contents:
00:00 - Introduction
00:16 - Formula method using LEN, SEQUENCE, MID and CONCAT
02:09 - VBA method using the StrReverse function
------------------------
Видео Reverse Text String (Without VBA) Using Formula or With VBA Using StrReverse Function | Mirror Text канала Chester Tugwell
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Line of Best Fit - Excel Chart | Plus Understanding the y=x Equation
Boot Windows 8.1 to Desktop instead of Start Screen
Highlight and Count Duplicate Rows In Excel | Highlight Duplicate Rows in Excel Except First
Calculate Variance and Standard Deviation in Excel | Sample & Population
Protect or Lock Sheets or Ranges in Google Sheets
Create a Basic Gantt Chart in MS Excel (Including Percentage Complete Progress Tracking)
Excel 2013 NUMBERVALUE: Convert Foreign Currency as Text to Numbers
Excel Subtract IF | Subtract If Not Blank | If Match Then Subtract | Subtract If Cell Contains Text
Extract Special Characters - 2 Methods: LAMBDA Function with Recursion or VBA User Defined Function
Can Excel Handle Dates Before 1900 (Yes!) | Difference in Years, Month or Days
Excel FILTER Function | Non Adjacent Columns | Return Specific Columns & Reorder Columns
Task Path Highlighting in Project 2013 NEW FEATURE!
How to Keep a Chart (or Charts) Visible when Scrolling in Excel?
Excel VBA - Hide Unhide ALL Worksheets
Add Apps to Your Desktop in Windows | Create a Desktop Shortcut for Applications
Create User Defined / Custom Function in Excel Using the LAMBDA Function - No VBA Required.
Excel VBA to Hide Worksheets Based on Sheet Tab Colour
How to Make a Certificate in Microsoft Word | Student Certificate of Participation in MS Word
Use the GOOGLEFINANCE Function to Create a LIVE Stocks and Shares Portfolio Tracker in Googlesheets
How to Calculate and Type Exponents (Power, Indices) in Excel | Square, Square Root, Cube, Cube Root
AVERAGEIFS Function Excel | Single or Multiple Criteria | AVERAGEIFS Between Two Dates