Most of the time, the data in Excel is arranged in columns, and it is more common to split the text in a cell into multiple columns rather than rows.| Trump Excel
It's easy to extract usernames from Email Ids in excel. You can either you a formula and make it dynamic, or use Text to Column and do it quickly| Trump Excel
In this tutorial, you'll learn the techniques to transpose data in Excel. You can use the Paste Special option, Transpose Function or a Custom Macro.| Trump Excel
Learn how to number rows in Excel in a few easy steps. In this tutorial, I'll show you 7 methods to insert rows numbers (aka serial numbers) in a dataset.| Trump Excel
Most of the time, when working with Excel, you need to restructure your data before you can start any kind of analysis.| Trump Excel
Learn how to use different ways to slice and dice text data (separate first and last name in Excel). It uses formulas, FLash Fill, Text to Columns, & more..| Trump Excel
Learn a couple of ways to remove the time from date in Excel. You can use a formula or Find and Repalce to Text to Columns to remove time from timestamp| Trump Excel
In this video, learn some quick and easy ways to remove the first character from a text string in cells in Excel (using formulas, Text to Columns, & VBA)| Trump Excel
Learn how to split cells in Excel (split a cell into multiple columns) using Text to Column, text functions or Flash Fill| Trump Excel
There are a lot of option to sort data in Excel. In this in-depth tutorial, I will show you all these option to sort in Excel (by date, text, number, color)| Trump Excel
Learn how to spit multiple lines in a single cell into different cells using Text to Columns functionality. You need to use Control J to specify line break.| Trump Excel
In this tutorial, learn how the concatenate formula works and how you can quickly concatenate excel range (with or without separators)| Trump Excel
While this may be a basic question for many Excel users, I have been asked multiple times about the difference between rows and columns in Excel.| Trump Excel
In this tutorial, you'll learn how to unhide columns in Excel. You can use the keyboard shortcut, options on the ribbons or change the column width.| Trump Excel
In this article, I wanted to create an overall structure that any Excel user can follow to enhance their basic, intermediate, or advanced Excel skills.| Trump Excel
In this tutorial, you'll learn how to wrap text in Excel. There are different methods to wrap the text in cells - keyboard shortcut, ribbon option, etc.| Trump Excel
Learn all about Excel autofit - a feature to fit the text automatically in a column or rows. In this tutorial, I cover 3 ways to Autofit text in Excel| Trump Excel