Formula Question!

[carrieebacon]

In cells Q6, Q7, and Q8 I have formulas that are populating data from A6 to N6. Is there a way to make this one formula instead of 3 and paste it down?

What I have now:

=A6&"#"&B6

=C6&D6

=E6&"("&F6&")"&":"&G6&"'"&"-"&N6

 

[dreid1011]

Possible yes. Can you post some sample data and the expected result after it's all combined?

 

[carrieebacon]

Here is a screenshot. the result is on the right.

 

[dreid1011]

Here is a screenshot. the result is on the right.




View attachment 105384

You want 3 lines of output per 1 line of input? Or 1 line to 1 line?

 

[carrieebacon]

3 lines of output per 1 line of input

 

[dreid1011]

3 lines of output per 1 line of input

Okay, with your current layout, dragging the formulas down as a set is neither intuitive or ideal for what you want to achieve. If you drag them down as a set, it skips two rows of input data. You can, however, combine the formulas like below, turn on wrap text for column Q and expand your row height to 60 to achieve "3 lines of output for 1 line of input".

Book1 1-18-2024.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	STR.	ID	TOP	ELV.	INV.	DIR.	ELV.	INV.	DIR.	ELV.	INV.	DIR.	ELV.	PIPE
2	CI	11	FR:		INV. IN	W		INV. IN	N		INV. OUT	E		18"RCP			CI#11 FR: INV. IN(W):'-18"RCP
3	CI	15	FR:		INV. IN	N		INV. IN	E		INV. OUT	S		12"RCP			CI#15 FR: INV. IN(N):'-12"RCP
4	CI	154	FR:		INV. IN	E		INV. OUT	W		0	0		12"RCP			CI#154 FR: INV. IN(E):'-12"RCP
5	CI	155	FR:		INV. IN	E		INV. OUT	W		0	0		18"RCP			CI#155 FR: INV. IN(E):'-18"RCP
6	CI	156	FR:		INV. IN	E		INV. OUT	W		0	0		12"RCP			CI#156 FR: INV. IN(E):'-12"RCP
7	CI	157	FR:		INV. IN	E		INV. OUT	W		0	0		18"RCP			CI#157 FR: INV. IN(E):'-18"RCP
8	CI	164	FR:		INV. OUT	W		0	0		0	0		12"RCP			CI#164 FR: INV. OUT(W):'-12"RCP
9	CI	165	FR:		INV. IN	E		INV. OUT	W		0	0		15"RCP			CI#165 FR: INV. IN(E):'-15"RCP
10	CI	167	FR:		INV. OUT	E		0	0		0	0		18"RCP			CI#167 FR: INV. OUT(E):'-18"RCP
11	CI	169	FR:		INV. IN	N		INV. OUT	S		0	0		13"RCP			CI#169 FR: INV. IN(N):'-13"RCP
Sheet6

Cell Formulas
Range	Formula
Q2:Q11	Q2	=A2&"#"&B2&CHAR(10)&C2&D2&CHAR(10)&E2&"("&F2&")"&":"&G6&"'"&"-"&N2

 

[carrieebacon]

Thank you SO much!

 

[dreid1011]

Thank you SO much!

You're welcome, and happy to help.