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))))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 07:20 AM.