Hi all, Hope you are doing good. Here I am again :slight_smile: My attention is to create running number. Eg : GE-2103-1000-Rev.0 User will enter the date and other details and running number will create by his own. From the date, 21 in the beginning refer to the year. 03 after refer to the m…

[image] vijay: Darren’s and Manu’s solution will generate in the same row, but to generate in the next row will require a different solution. My solution provides an auto-incrementing column. So every time a new row is added, the number in that column will auto-increment by 1. Is that not w…

Take Certain Text In Cell

Ask for Help

Darren_Murphy March 5, 2021, 9:26am 6

Topic		Replies	Views
Need Month Name (text) and Year from Date Ask for Help	14	916	February 14, 2024
How to make running number and concatenate data? Ask for Help	1	679	August 23, 2022
Pulling text, like you can with the FIND MID formula of Excel Ask for Help	10	49	October 18, 2024
Date Math - comparing today to a certain date with a dynamic year Ask for Help	13	702	January 17, 2024
ID's for lines Ask for Help	21	1089	June 3, 2021

Take Certain Text In Cell

Related topics