Insert text after Nth character within every cell in Excel

Опубликовано: 02 Октябрь 2024
на канале: ExtendOffice
365
3

Tutorial: https://www.extendoffice.com/document...
Download link for Kutools for Excel: https://www.extendoffice.com/download...

In this video, we'll explore two methods to insert specific text after the Nth character in each cell: one using a REPLACE formula and the other with a versatile tool. As an example, we'll show how to insert a hyphen (-) after the 5th character.

==================================================

0:00:00 Insert text after Nth character within every cell

0:00:14 Using the REPLACE function
0:01:24 Using Kutools for Excel