Share via

How Do I

Anonymous
2025-03-24T21:00:53+00:00

How do I adjust the formula in the "C" column to put a space between Comparable Sales #40.00%. I would like it to read for cell C12 "Comparable Sale #4 0.00%"

Below is the formula

Column G needs t ostay two lines, too be used in a graph.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2025-03-24T22:29:45+00:00

Select column C

On the Home tab of the ribbon, in the Alignment group, click to highlight the Wrap Text button.

Alternatively, change the formula in C4 to

=IFERROR(SUBSTITUTE(VLOOKUP(TEXT(A4, "mmmm yyyy"), $E$4:$G$15, 3, FALSE), CHAR(10), " "), "")

or

SUBSTITUTE(XLOOKUP(TEXT(A4, "mmmm yyyy"), $E$4:$E$15, $G$4:$G$15, ""), CHAR(10), " ")

Fill down.

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest