Page 19-excel-php.cn

Article Tags

All
web3.0
- IIS
- SEO
- Premiere
Backend Development
- IIS
- SEO
- Premiere
Web Front-end
- IIS
- SEO
- Premiere
Database
- IIS
- SEO
- Premiere
Operation and Maintenance
- IIS
- SEO
- Premiere
Development Tools
- IIS
- SEO
- Premiere
PHP Framework
- IIS
- SEO
- Premiere
Common Problem
- IIS
- SEO
- Premiere
Other
- IIS
- SEO
- Premiere
Tech
- IIS
- SEO
- Premiere
CMS Tutorial
- IIS
- SEO
- Premiere
Java
- IIS
- SEO
- Premiere
System Tutorial
- IIS
- SEO
- Premiere
Computer Tutorials
- IIS
- SEO
- Premiere
Hardware Tutorial
- IIS
- SEO
- Premiere
Mobile Tutorial
- IIS
- SEO
- Premiere
Software Tutorial
- IIS
- SEO
- Premiere
Mobile Game Tutorial
- IIS
- SEO
- Premiere

Home

Technical Articles

Topics

excel

Excel CONCAT function - string concatenation examples

This tutorial explores the Excel CONCAT function, a streamlined way to combine text strings from multiple cells. It also highlights key differences from its predecessor, CONCATENATE. Learn to concatenate with various delimiters (spaces, commas, line

Mar 28, 2025 am 10:27 AM

Excel Data Validation using regular expressions (Regex)

The tutorial shows how to do data validation in Excel using regular expressions with the help of a custom RegexMatch function. When it comes to restricting user input in Excel worksheets, Data Validation is indispensable. Want to allow on

Mar 28, 2025 am 10:25 AM

How to convert table to normal range in Excel and vice versa

This article explains how to quickly convert a cell range into an Excel table using a chosen table style, and how to revert a table back to a standard range. Excel tables simplify data management, calculation, and updates. However, sometimes a table

Mar 28, 2025 am 10:19 AM

Regex to remove certain characters or text in Excel

Have you ever thought how powerful Excel would be if someone could enrich its toolbox with regular expressions? We have not only thought but worked on it :) And now, you can add this wonderful RegEx function to your own workbooks and wipe

Mar 28, 2025 am 10:11 AM

How to add text or specific character to Excel cells

This tutorial demonstrates several easy methods to add text to existing Excel cells. Whether you need to add prefixes, suffixes, or text within a string, this guide provides solutions using formulas and VBA. Working with text data often requires add

Mar 28, 2025 am 10:05 AM

Remove text before, after or between two characters in Excel

This tutorial explores various Excel techniques for removing text before, after, or between specific characters within strings. We'll cover several methods, from simple Find & Replace to powerful formulas and a custom VBA function, culminating i

Mar 28, 2025 am 10:04 AM

How to view shared files in OneDrive and stop sharing

This guide explains how to locate and manage files and folders shared with you on OneDrive, and how to adjust sharing permissions. OneDrive simplifies document sharing and collaboration; however, finding shared items can sometimes be tricky. This g

Mar 28, 2025 am 09:48 AM

How to remove text or character from cell in Excel

This tutorial demonstrates efficient methods for removing text portions from Excel cells using formulas and built-in tools. Need to delete specific text across multiple cells? Remove leading/trailing characters? Or perhaps just a particular charact

Mar 28, 2025 am 09:26 AM

How to create and use User Defined Functions in Excel

This article demonstrates how to create and use custom functions in Excel to streamline tasks beyond the capabilities of standard functions. It explores the creation of user-defined functions (UDFs) using VBA, offering a solution for handling data p

Mar 28, 2025 am 09:14 AM

Excel Regex: match strings using regular expressions

In this tutorial, we'll have an in-depth look at how to use regex to match strings in Excel. When you need to find a certain value in a range of cells, you'd use the MATCH or XMATCH function. When looking for a specific string in a cell,

Mar 28, 2025 am 09:13 AM

Custom functions to count colored cells in Google Sheets: CELLCOLOR & VALUESBYCOLORALL

This tutorial introduces 2 new functions from our Function by Color add-on for Google Sheets: CELLCOLOR & VALUESBYCOLORALL. Use them to sum & count cells not only by their colors but also by the common contents. Ready-made IF, SUM

Mar 28, 2025 am 09:06 AM

Excel UDF not working: problems and solutions

This article addresses common problems encountered when using custom functions (UDFs) in Excel. We'll explore troubleshooting solutions for recalculation issues, volatile vs. non-volatile functions, function unavailability, and missing help text. Ke

Mar 28, 2025 am 09:04 AM

Advantages and drawbacks of custom functions in Excel

This tutorial continues our series on user-defined functions (UDFs) in Excel. Previous articles covered UDF creation and usage; this one delves into practical application and contrasts UDFs with VBA macros. Key Learning Objectives: Understanding th

Mar 28, 2025 am 09:03 AM

Remove whitespaces and empty lines in Excel using Regex

Wish to handle whitespaces in the most effective way? Use regular expressions to remove all spaces in a cell, replace multiple spaces with a single character, trim spaces between numbers only, and more. Whichever input data you are using,

Mar 28, 2025 am 09:02 AM