Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

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

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.
0
TIMFOX123
Asked:
TIMFOX123
1 Solution
 
bitrefCommented:
=CONCATENATE("ssh paul@",G1)
0
 
TIMFOX123Author Commented:
thx
0
 
MaximumIQCommented:
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
0
 
bggauthCommented:
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
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now