Next Number In Sequence?

[Elliot46]

Hi All,

New here and new to excel really... I had a question & don't know if it is something easily solved.

Below is a screen grab of a work drawing list with drawing numbers as per below example... D0001, D0002, D0003 etc.

Is there anyway to get the cell below (Next Drawing No.) to automatically update with the next number in the sequence, after D0003 respectively is entered into a cell? Taking into consideration that previous numbers
will be entered frequently with letters a, b, c etc behind them for drawing revisions.

Thank you for any help in advance.

Regards,
Elliot

 

[Sufiyan97]

Hi Rory

Why formula does not work without "\"

 

[RoryA]

Because D is a built-in custom format code (for day) so it needs to be escaped to be a literal D.

 

[Sufiyan97]

Because D is a built-in custom format code (for day) so it needs to be escaped to be a literal D.

Thanks for the info.

one more
Does "\" always used to specify the format?

 

[Legacy 143009]

Oh, also I didn't know that. Then my formula needs "\", too..

 

[RoryA]

Does "\" always used to specify the format?

\ is an escape character for the character that follows it. You can also enclose them in quotes - since the format string is already in quotes for the TEXT function, you'd need to double them so using \ was easier.