Formula to add +1 to a sequence

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to add +1 to a sequence

FAQ

Thread Tools

Display Modes

05-03-2020, 03:33 PM

macropod

Windows 7 64bit Formula to add +1 to a sequence

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

For example:
="RE249869000xxx-" & TEXT(ROW()-1,"00")& "-xxxx-0001"
However, this isn't going to produce RE249869000xxx-99-xxxx-0001 on row 12. The logic for that result escapes me.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format in a formula month and numbers	Marcia	Excel	10	02-28-2019 05:55 AM
How make IF Formula return a numbers joined with a letter	Strogg	Word	11	01-07-2019 03:13 PM
Create a sequence of numbers using a formula	14spar15	Excel Programming	9	03-19-2018 01:15 AM
Link to automated table and formula numbers	Jacky837	Word	1	07-25-2016 10:45 AM
Find & Replace formula for numbers?	Griff	Word	4	04-18-2011 02:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:41 AM.