<div>
No comments afterlong time. resolve by myself. &nbsp;write first one value to description then get it again as variable &nbsp;and write it with other variable
</div>


No comments afterlong time. resolve by myself.  write first one value to description then get it again as variable  and write it with other variable

<div>
<div class="content wysiwyg-content">
Dear friends,<br />
<br />
the &nbsp;problem in this formula is &quot;&amp;amp;L151&amp;amp; $db&quot;<br />
ii've a special case to insert Text from a cell with result of variable to description. How could i write that?<br />
<br />
=&quot;$db = (Get-Mailbox -Identity &quot;&amp;amp;A151&amp;amp;&quot; | Select-Object -expand Database);;set-aduser -identity &quot;&amp;amp;A151&amp;amp;&quot; &nbsp;-description &quot;&amp;amp;L151&amp;amp; $db&quot;<br />
<br />
L151 contents the text. the result should be &nbsp;&quot;text &nbsp;DB001&quot;<br />
$DB is e.g. DB001<br />
<br />

<pre><code id="code-10-28519998-1">=&quot;$db = (Get-Mailbox -Identity &quot;&amp;amp;A151&amp;amp;&quot; | Select-Object -expand Database);;set-aduser -identity &quot;&amp;amp;A151&amp;amp;&quot;  -description &quot;&amp;amp;L151&amp;amp; $db&quot;</code></pre>
<br />
Thanks in advance
</div>
</div>


Dear friends,

the  problem in this formula is "&amp;L151&amp; $db"
ii've a special case to insert Text from a cell with result of variable to description. How could i write that?

="$db = (Get-Mailbox -Identity "&amp;A151&amp;" | Select-Object -expand Database);;set-aduser -identity "&amp;A151&amp;"  -description "&amp;L151&amp; $db"

L151 contents the text. the result should be  "text  DB001"
$DB is e.g. DB001

(CODE)

Thanks in advance

powershell Excel formula data resolving for powershell

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.