<div>
without getting into scripting, an easy creative way to do this is as follows. You can use a similar concept for alot indirect cell editing.<br />
<br />
1. insert a new column before the one you have your values in. <br />
2. copy the new column and the one with your values.<br />
3. paste them in notepad (this will show everything with a {Tab} before it<br />
4. highlight from the beggining of any line to the beggining of any line to the beginning of your word and copy (basically you're copying a {tab}<br />
5. go to Edit =&gt; Replace<br />
6. Paste the {tab} in &quot;What to Find&quot; and replace it with ssh paul@<br />
7. now copy everything from notepad and paste it back in excel<br />

</div>


without getting into scripting, an easy creative way to do this is as follows. You can use a similar concept for alot indirect cell editing.

1. insert a new column before the one you have your values in.
2. copy the new column and the one with your values.
3. paste them in notepad (this will show everything with a {Tab} before it
4. highlight from the beggining of any line to the beggining of any line to the beginning of your word and copy (basically you're copying a {tab}
5. go to Edit => Replace
6. Paste the {tab} in "What to Find" and replace it with ssh paul@
7. now copy everything from notepad and paste it back in excel


<div>
Column A &nbsp; &nbsp; &nbsp;Column B &nbsp; &nbsp; &nbsp; &nbsp;Column C<br />
Tim &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Fox &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Tim Fox<br />
ssh paul@ &nbsp; &nbsp;bart.com &nbsp; &nbsp; &nbsp;ssh paul@bart.com &nbsp; <br />
<br />
<br />
Column C would be this... &nbsp;=A2&amp;&quot; &quot;&amp;B2 <br />
Obviously copy that down the list of 500<br />

</div>


Column A      Column B        Column C
Tim                 Fox                 Tim Fox
ssh paul@    bart.com      ssh paul@bart.com  


Column C would be this...  =A2&" "&B2
Obviously copy that down the list of 500


<div>
<div class="content wysiwyg-content">
I have a row of server names in row G.<br />
bart.com<br />
flagship.com<br />
flitstone.com<br />
<br />
I want to change the row to read <br />
<br />
ssh paul@bart.com<br />
ssh paul@flagship.com<br />
ssh paul@flitstone.com<br />
<br />
<br />
thanks <br />
<br />
this is an example, I actually have 500 names to change. <br />

</div>
</div>


I have a row of server names in row G.
bart.com
flagship.com
flitstone.com

I want to change the row to read 

ssh paul@bart.com
ssh paul@flagship.com
ssh paul@flitstone.com


thanks 

this is an example, I actually have 500 names to change. 


How in excel do I insert text in front of my cell ?

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