HDTutorial
EN
How to Increment Letters and Number Combinations LTS0001 becomes LTS0002 etc

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Increment Letters and Number Combinations LTS0001 becomes LTS0002 etc

37,019 views November 15, 2013 24:18

Watch on YouTube
ChannelExcelVbaIsFun

Description from the creator

📊 Free Workbooks: excelvbaisfun.com/links?utm_source=youtube&…
🥷Join Excel Ninja Pro: excelvbaisfun.com/ninjapro🔥(2 Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)

In this lesson, we take a sheet with varying Letters followed by a sequence number and learn to increment the correct Item number in sequence. So if the last COPPER unit was COP0001, then the next one should be COP0002, and if the last SILVER one was SIL0016 then

Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: excelvbaisfun.com/secure-excel-files (25% off with code ‘25OFF’)
🟡 Create Custom Installers: excelvbaisfun.com/custom-installers
👋 Business Inquiries, Consulting, Comments, etc: excelvbaisfun.com/contact/

About this tutorial

ExcelVbaIsFun published this 24:18 video tutorial on November 15, 2013. It has been watched 37,019 times on YouTube.

Category
Education
Duration
24:18
Published
November 15, 2013
Views
37,019
Likes
176

Share

This tutorial in other languages