Formatting cells

[cadandcode]

How can I add blanks between 29 and GÜNLÜK RAPOR to move GÜNLÜK RAPOR under the 29?
What I try to do is making right part that contains "29 GÜNLÜK RAPOR" look like A+B+C cells that contains "MAYIS 2023 Son imalat günü 29.05.2023"
Left part that starts with Mayıs 2023's second line moves below by using wrap text button. I can add blanks between "Mayıs 2023" and "Son imalat günü 29.05.2023" to move second part under the "Mayıs 2023".
The cell that I put number and make it look like "29 GÜNLÜK RAPOR" has only number. Formatting cells made it look like 29 GÜNLÜK RAPOR but I cant put blanks between "29" and "GÜNLÜK RAPOR".
"GÜNLÜK RAPOR" part just moves right but never goes under "29" like I did before in A+B+C cells.
You can say fill the cell like I did before for A+B+C cells but I just want to put there a number. Because another cell turns that number and put it in a calculation. So the cell should contain only number, therefore I need to use cell format.
EDIT: Well it looked pretty bad idk why, it looks like in the screen I will now attach.

genel ortalama ilerleme.xlsx
	A	B	C	D
1	MAYIS 2023 Son imalat günü 29.05.2023			29 GÜNLÜK RAPOR
2	SAĞ TÜP 20 GÜN İMALAT YAPILDI (B3 devam ediyor)		SOL TÜP 22 GÜN İMALAT YAPILDI (C2 devam ediyor)
3	B3	C2	B3	C2
4	18 m	53 m	45 m	32 m
5	Toplam İlerleme 148,00 m
6	B3		C2
7	63 m		85 m
8	GENEL ORTALAMA
9	Günlük B3 İlerleme		2,17 metre/gün
10	Günlük C2 İlerleme		2,93 metre/gün
Sayfa1

Cell Formulas
Range	Formula
A5	A5	=A7+C7
A7	A7	=+A4+C4
C7	C7	=+B4+D4
C9	C9	=A7/D1
C10	C10	=C7/D1

 

[scoudny]

Hi Cad, you're English is better than my Turkish but are you saying you want the 29 above GÜNLÜK RAPOR in the same cell?
If so its Alt and Enter to add a level within the cell.

 

[cadandcode]

Hi Cad, you're English is better than my Turkish but are you saying you want the 29 above GÜNLÜK RAPOR in the same cell?
If so its Alt and Enter to add a level within the cell.

Didnt work

 

[awoohaw]

@cadandcode , when you attempted to add the "ALT-ENTER" did you click inside the cell (between 29 and GULAK)? And is the cell formatted with "Wrap"?

a similar way to do this would be to type this in the cell:
(also formatted with wrap)

="29" & char(10) & "GÜNLÜK RAPOR"

If that doesn't work try char(13) in the formula.

 

[scoudny]

You typed 29, held alt & Enter and it didn't add a level for you to type GÜNLÜK RAPOR

 

[cadandcode]

You typed 29, held alt & Enter and it didn't add a level for you to type GÜNLÜK RAPOR

View attachment 93396

Yes. It didnt look like that. 29 and a blank below it.
@awoohaw nope, didnt work.

 

[awoohaw]

OK. I misunderstood.
Can you share with the forum what the custom number format is for cell D1.

This is what I get from copying the xl2bb in my version of excel (So I don't think the custom format carried over):

What you are asking for is a custom format "text" that has a carriage return in it.
I've seen it mentioned in the custom formatting chatter and discussions but I've never seen it working.

 

[cadandcode]

You typed 29, held alt & Enter and it didn't add a level for you to type GÜNLÜK RAPOR

View attachment 93396

@awoohaw this is the result of what I want to see in cell. It is actually "29 GÜNLÜK RAPOR" in same line but I want it look like that example. When I type number, it should look alike that. Number is above, text is below. But cell contains only "29" as number and the rest of all is cell formatting like 0 "GÜNLÜK RAPOR" in cell format.

genel ortalama ilerleme.xlsx
	A	B	C	D
2	12 GÜNLÜK RAPOR
haziran 23

 

[awoohaw]

Okay, I got it to work.
In the custom format cell in the format number window type # then [cntl-j] then "GUNLAK RAPOR"
the [CNTL]=j] inserts a carriage return (so you will not see "GUNLAK RAPOR" in the "Type" window, but it is below in the custom format list, the [CNTL-j] is not visible.
See the image below, which also shows cell D1 with the return in the format:

 

[awoohaw]

Here is the link to the page where I found it:

Redirecting