Macro to segregate space tab separated fields - meeting specific text condition
Dear experts,
[For the purpose of this explanation, let me say when I open the file with file type
…![Excel]()
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...
Read more- 144K Content
- 12K Contributors
Expert Spotlight
Finance Analyst
30 years in Financial Services and Management Accounting. CIMA trained but prefer the technical or system aspects of accounting.
Leading Experts In
Troubleshooting Solution
Article
Generate Visio flowcharts and swimlane diagrams from data
The Data Visualizer (DV) add-in for Excel provides a powerful, fast way to build flowcharts and swimlane diagrams from data.
And you don’t even need a Visio license to make this magic happen!
Video
Creating an Efficient Dashboard in Excel
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will …
Post
The Course of the Month for May: Comp TIA A+! Prepare for …
The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Prepare for the 220-901 & 220-902 exams in the month…
Troubleshooting Solution
Excel Zone Expert Discussion, Number 33
This thread is for general discussion about all things related to the Excel zone and its experts. …
Article
How to quickly and accurately populate Word documents with Excel data, charts, and images (including Automated Bookmark generation)
How to quickly and accurately populate Word documents with Excel data, charts and images …
Article
Generate and update Org Charts automatically in Visio
For decades, the Visio org chart wizard has generated diagrams from data automatically. But all subsequent changes were manual and required recreating the diagram. The Visio Data Visualizer changes the game -- you can either change the data or the diagram and then update the other with one click.
Troubleshooting Solution
Excel VBA
I have a spreadsheet with a number of columns and rows as an exported set of values
I need to carry
…
Article
Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work
by Patrick G. Matthews
Introduction
VLOOKUP is a tremendously useful function …
Introduction
VLOOKUP is a tremendously useful function …
Troubleshooting Solution
Amendment of MAcro to include the filename from where the records has been copied and pasted
Dear experts,
Below is a macro which was put together to perform the operation of putting all files
…
Article
A Guide to Writing Understandable and Maintainable VBA Code
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Article
Creating a custom Welcome form in Excel
Not too long ago I wrote this article on doing the same thing in MS Access (https://www.experts-exchange.com/articles/38421/Making-your-Database-More-User-Friendly.html). I found that a similar "Welcome" screen makes Excel worksheets "friendlier" as well.
Video
Can ChatGPT 4 or Google Bard write Excel formulas?
We previously tested ChatGPT 3 and other AI tools to see if they can write Excel formulas. In this …
Post
Once upon a time at a core conference this …
Once upon a time at a core conference this…
Video
How to use the new SCAN function in Excel
Creating a running total is a common task but it can get complicated. So Microsoft is introducing a …
Video
Automatic Calculations in Excel for Web
Another excellent feature Microsoft added to Excel is automatic calculations! It doesn’t mean you …
Troubleshooting Solution
Display if item is new
Hi Experts,
I have a list of items which contains many duplicates.
List consists of ASIN's and many
…
Post
New member today got a solution today. After searching …
New member today got a solution today.
After searching the net for help it became apparent…
After searching the net for help it became apparent…
Video
Inserting Checkboxes in an Excel Worksheet
If you ever wanted to insert a checkbox in an Excel worksheet, you know it wasn’t easy or …
Explore solutions and more
![Excel]()
Microsoft ExcelBack to the top
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.