Is there a formula for filling data from right to left?

[bamacwby]

Morning all,
I am trying to get data to be input from cells D1 to A1 (right to left) for a single digit but possibly up to 5 digits. Thank you.

 

[Jeffrey Mahoney]

Do you have a good sense of humor bamacwby? The reason I ask is because I wanted to be flippant as a response to you statement above because you're not asking a question. Usually I don't respond to these kinds of posts. The title of the thread is a question, but between the title and the statement I can't make sense of the request.

A formula cannot change the values of other cells. A series of formulas could read a single cell and break it into different sections based on a delimiter or other rules.

Can you please be more specific.

Jeff

 

[bamacwby]

Do you have a good sense of humor bamacwby? The reason I ask is because I wanted to be flippant as a response to you statement above because you're not asking a question. Usually I don't respond to these kinds of posts. The title of the thread is a question, but between the title and the statement I can't make sense of the request.

A formula cannot change the values of other cells. A series of formulas could read a single cell and break it into different sections based on a delimiter or other rules.

Can you please be more specific.

Jeff

If you look in the image I attached, I am trying to get the 0 in cell Z6, with the formula shown, to be input into cell AC6. At times Column 6 may have up to four numbers depending on what number i assign to the corresponding cell in the "Engine Formulas" tab.

 

[Jeffrey Mahoney]

Are you saying you want to display a zero if Cell 'Engine Formulas'!E4 has no value, otherwise you want to display each number in 'Engine Formulas'!E4 across Z6:AC6?

Book2
	Z	AA	AB	AC
6	0
7	1	2	3	4
Engine

Cell Formulas
Range	Formula
Z6,Z7:AC7	Z6	=IF(LEN('Engine Formulas'!E4)=0,0,MID('Engine Formulas'!E4,SEQUENCE(,LEN('Engine Formulas'!E4)),1))

 

[Scott Huish]

Does this do what you want?

=MID(TEXT('ENGINE FORMULAS'!E4,"0000"),SEQUENCE(1,4),1)

 

[Snakehips]

@bamacwby I'm thinking you need formula like below?

AutoTraining.xlsm
	X	Y	Z	AA	AB	AC	AD
5
6						0
7				1	2	3
8			9	3	6	5
9
Tracker

Cell Formulas
Range	Formula
X6:AC8	X6	=LET(s,REPT(" ",6-LEN('Engine Formulas'!E4))&'Engine Formulas'!E4,MID(s,SEQUENCE(,LEN(s),),1))
Dynamic array formulas.

AutoTraining.xlsm
	D	E	F
4		0
5		123
6		9365
7
Engine Formulas

HTH

 

[bamacwby]

Are you saying you want to display a zero if Cell 'Engine Formulas'!E4 has no value, otherwise you want to display each number in 'Engine Formulas'!E4 across Z6:AC6?

Book2
	Z	AA	AB	AC
6	0
7	1	2	3	4
Engine

Cell Formulas
Range	Formula
Z6,Z7:AC7	Z6	=IF(LEN('Engine Formulas'!E4)=0,0,MID('Engine Formulas'!E4,SEQUENCE(,LEN('Engine Formulas'!E4)),1))

That still puts the 0 in cell Z6. I need the 0 in cell AC6 and if the number in cell "Engine Formulas E4 is 911, I need the numbers to start in cell AC6 and go right to left

 

[Scott Huish]

@bamacwby I'm thinking you need formula like below?

AutoTraining.xlsm
	X	Y	Z	AA	AB	AC	AD
5
6						0
7				1	2	3
8			9	3	6	5
9
Tracker

Cell Formulas
Range	Formula
X6:AC8	X6	=LET(s,REPT(" ",6-LEN('Engine Formulas'!E4))&'Engine Formulas'!E4,MID(s,SEQUENCE(,LEN(s),),1))
Dynamic array formulas.

AutoTraining.xlsm
	D	E	F
4		0
5		123
6		9365
7
Engine Formulas

HTH

I think if leading spaces are wanted, I think that this would suffice:
=MID(RIGHT(REPT(" ",4)&'Engine Formulas'!E4,4),SEQUENCE(1,4),1)

 

[Scott Huish]

However you said sometimes 5 but your examples uses 4 cells. Can you please clarify?

 

[Jeffrey Mahoney]

How about this?

Book2
	Z	AA	AB	AC
5	0	0	0	0
6	3	2	1	0
Engine

Cell Formulas
Range	Formula
Z5:AC6	Z5	=LET(TXT,TEXT('Engine Formulas'!E4,"0000"),MID(TXT,SEQUENCE(,4,4,-1),1))
Dynamic array formulas.