Formula to fill in sequence

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to fill in sequence

04-17-2021, 01:42 AM

xor

Windows 10 Formula to fill in sequence

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

For those having access to TEXTJOIN and SEQUENCE:

=TEXTJOIN(" ",TRUE,TRANSPOSE(SEQUENCE(RIGHT(A2,4)-LEFT(A2,4)+1,,
--LEFT(A2,4))))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to add +1 to a sequence	Benali	Excel	6	05-05-2020 03:47 AM
Formula to calculate fill need between two circles	wolfgrrl	Excel	2	07-08-2019 04:10 AM
Create a sequence of numbers using a formula	14spar15	Excel Programming	9	03-19-2018 01:15 AM
Formula for number sequence	14spar15	Excel Programming	4	03-18-2018 07:00 PM
Need an excel formula to remove dashes in a number sequence	jyfuller	Excel Programming	3	02-27-2013 10:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:53 AM.