Microsoft Office Forums - View Single Post - [Solved] Formula to fill in sequence

Thread: [Solved] Formula to fill in sequence

View Single Post

Old

04-17-2021, 01:42 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

For those having access to TEXTJOIN and SEQUENCE:

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

Reply With Quote