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	205	February 14, 2024
Date Math - comparing today to a certain date with a dynamic year Ask for Help	13	622	January 17, 2024
Question Math: get value from prior cell? Ask for Help	1	449	October 5, 2020
Summarising running data for different periods Ask for Help	3	473	January 5, 2023
How to extract only the numbers from a cell that has both text and numbers? Ask for Help	6	155	August 18, 2023

Take Certain Text In Cell

Related Topics