Solved

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

Posted on 2011-03-24
4
266 Views
Last Modified: 2012-05-11
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
Comment
Question by:TIMFOX123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 5

Accepted Solution

by:
bitref earned 500 total points
ID: 35210200
=CONCATENATE("ssh paul@",G1)
0
 

Author Closing Comment

by:TIMFOX123
ID: 35210226
thx
0
 
LVL 4

Expert Comment

by:MaximumIQ
ID: 35210230
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
 
LVL 2

Expert Comment

by:bggauth
ID: 35210259
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question