Forum Discussion
Take data from excel cells and make a sentence
Hi,
I have a form of 8 cells (as you can see in the attached picture) & I need to get the values in a sentence like in the picture. If possible is there a way to calculate duration as well in the code?
Please be kind enough to share a code with me to get this done ASAP. Thank in advance!
Hi,
Can you show us the complete url/path you configured ?
And how did you deployed those templates? Like this or?
Create an organization assets library - SharePoint in Microsoft 365 | Microsoft Docs
2 Replies
=A2& " | "&TEXT(C2,"$#,##0")&" | "&DATEDIF(D2,E2,"m")&" month(s)"&CHAR(10)&"Location: "&G2&", US Geo Focus: "&H2&CHAR(10)&F10
It is not possible to make part of the result of the formula bold. Excel does not support that.
- gettingittogether25Copper Contributor
HansVogelaar Works like a dream! Thank you!