SOLVED
Home

combining cells

%3CLINGO-SUB%20id%3D%22lingo-sub-269557%22%20slang%3D%22en-US%22%3Ecombining%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269557%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20get%20a%20cell%20that%20will%20say%2C%20%22Summary%20%5BDate%5D%22%20and%20I%20want%20the%20date%20to%20display%20the%20last%20date%20that%20the%20sheet%20was%20edited.%20I've%20tried%20to%20combine%20a%20cell%20that%20says%20summary%20and%20one%20that%20uses%20the%20today()%20function%2C%20I've%20tried%20to%20use%20'%3D%22Summary%20%22%26amp%3BTODAY()'%2C%20and%20multiple%20variations%20of%20those%2C%20and%20every%20variation%20returns%20the%20same%20result%2C%20%22Summary%2043383%22.%20Today's%20actual%20date%20is%2010%2F10%2F2018.%20In%20case%20that%20gives%20you%20a%20clue%20as%20to%20where%20the%2043383%20is%20coming%20from.%20I%20have%20no%20idea.%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-269557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269955%22%20slang%3D%22en-US%22%3ERe%3A%20combining%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269955%22%20slang%3D%22en-US%22%3E%3CP%3EHahaha%20Your%20rock%20Surgei!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269823%22%20slang%3D%22en-US%22%3ERe%3A%20combining%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269823%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Chris%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20you%20finish%20typing%20your%20text%20don't%20press%20arrow%20keys%20or%20Enter%2C%20press%20F2%20instead%20-%20you%20will%20enter%20in%20cell%20edit%20mode.%20Here%20select%20the%20part%20of%20the%20text%20you'd%20like%20to%20format%20and%20apply%20desirable%20text%20format%20(for%20one%20word%20you%20may%20double%20click%20on%20it%20to%20select).%20Enter%20after%20you%20finished.%20It%20will%20be%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20243px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F56009i56A10CA347CD1C0F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20existing%20texts%20focus%20on%20the%20cell%20and%20F2%20or%20double-click%20to%20edit.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269627%22%20slang%3D%22en-US%22%3ERe%3A%20combining%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269627%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Sergei!%20This%20is%20exactly%20what%20I%20was%20looking%20for.%20I%20also%20found%20out%20I%20can%20put%20my%20client%20name%20first%20and%20hit%20ALT%2BEnter%20before%20the%20second%20quotation%20mark%20and%20it%20will%20drop%20the%20following%20text%20to%20the%20next%20line.%20BONUS%20POINTS%20if%20you%20can%20tell%20me%20a%20way%20to%20make%20the%20client%20name%20a%20different%20font%20size%20%3BD%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269590%22%20slang%3D%22en-US%22%3ERe%3A%20combining%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269590%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Chris%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20since%20dates%20in%20Excel%20are%20actually%20numbers%2C%20you%20have%20to%20apply%20format%20to%20them%3C%2FP%3E%0A%3CPRE%3E%3D%22Summary%20%22%20%26amp%3B%20TEXT(TODAY()%2C%22mm%2Fdd%2Fyyyy%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Chris Walters
Occasional Contributor

I'm trying to get a cell that will say, "Summary [Date]" and I want the date to display the last date that the sheet was edited. I've tried to combine a cell that says summary and one that uses the today() function, I've tried to use '="Summary "&TODAY()', and multiple variations of those, and every variation returns the same result, "Summary 43383". Today's actual date is 10/10/2018. In case that gives you a clue as to where the 43383 is coming from. I have no idea. Please help.

4 Replies
Solution

Hi Chris,

 

That's since dates in Excel are actually numbers, you have to apply format to them

="Summary " & TEXT(TODAY(),"mm/dd/yyyy")

Thank you Sergei! This is exactly what I was looking for. I also found out I can put my client name first and hit ALT+Enter before the second quotation mark and it will drop the following text to the next line. BONUS POINTS if you can tell me a way to make the client name a different font size ;D

Hi Chris,

 

After you finish typing your text don't press arrow keys or Enter, press F2 instead - you will enter in cell edit mode. Here select the part of the text you'd like to format and apply desirable text format (for one word you may double click on it to select). Enter after you finished. It will be like

image.png

 

For the existing texts focus on the cell and F2 or double-click to edit.

Hahaha Your rock Surgei!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies