Some Excel help please

Phate · 20 Aug 2013 at 09:22

Hi guys,

For a global change I am looking to make I need some hand with excel to build the powershell commands

So I have the command

Code:

Set-MailboxCalendarConfiguration -Identity "X" -WorkingHoursStartTime 07:00:00

The X I would like to replace with a username

So I have the command copied down for all the users in Column A and the user names in Column B

Whats the best way to get this to pull the names from Column B and get it to replace X in Column A?

TIA
Jake

izzop · 20 Aug 2013 at 10:10

Hi,

If I've understood what you're after then in Column C: -

Code:

=SUBSTITUTE(A1,"X",B1)

Again just copy this down as required.

Phate · 20 Aug 2013 at 10:12

Ah perfect, that's done it.

Thank you

izzop · 20 Aug 2013 at 10:14

You're welcome, glad it's done the trick.