text change
in [Functions]
|
From: Eduardo on 19 May 2010 11:05 Hi John, How do you get Carlson, Glen from Gcarls, this is what we need you to explain us in order to help you "John" wrote: > To be clearer, what really want to do is find each incidence of "gcarls" in a > column and have each instance converted/replaced with "Carlson, Glen" > -- > John > > > "Eduardo" wrote: > > > Hi, > > Let's assume you have a list of full names in sheet2 in column A and the > > abbreviate name in column B, then in sheet 1 you have the abbreviate names in > > column A, so in column B enter > > > > =index(sheet2!$A$1:$A$10000,match(a1,$B$1:$B$10000,0)) > > > > "John" wrote: > > > > > I'll try this again as I accidentally hit the enter key after typing the > > > subject. In a spreadsheet I have all of my staff listed by their abbreviated > > > names used to identify them on our server. I want to be able to convert > > > there abbreviated names like "gcarls" to "Carlson, Glen". I think one of the > > > If formualtions will work but I'm having difficulty. Can anyone please tell > > > me how to do this? > > > -- > > > John
From: John on 19 May 2010 11:57 gcarls is his logon name in our system and will never change. I get reports that list things he does by his logon name and I want to convert it to his full name. -- John "Mike H" wrote: > John, > > How do we establish that gcarls becomes Carlson, Glen? > > Why for example doesn't that same username become Carlton, Geoff or any > other variation? > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "John" wrote: > > > I'll try this again as I accidentally hit the enter key after typing the > > subject. In a spreadsheet I have all of my staff listed by their abbreviated > > names used to identify them on our server. I want to be able to convert > > there abbreviated names like "gcarls" to "Carlson, Glen". I think one of the > > If formualtions will work but I'm having difficulty. Can anyone please tell > > me how to do this? > > -- > > John
From: Mike H on 19 May 2010 12:12 John. We really do want to help but your not providing sufficient information. > gcarls is his logon name in our system and will never change. What is 'our system'? > I get reports that list things he does by his logon name Where are these reports coming from? What is the reporting tool? Does 'the system' or 'Excel' have a table somewhere that lists full names and logon names? If it does you can query that table with a lookup in the way Eduardo showed you. In short, unless you have such a table that is available to Excel then what your asking can't be done. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "John" wrote: > gcarls is his logon name in our system and will never change. I get reports > that list things he does by his logon name and I want to convert it to his > full name. > -- > John > > > "Mike H" wrote: > > > John, > > > > How do we establish that gcarls becomes Carlson, Glen? > > > > Why for example doesn't that same username become Carlton, Geoff or any > > other variation? > > -- > > Mike > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > introduces the fewest assumptions while still sufficiently answering the > > question. > > > > > > "John" wrote: > > > > > I'll try this again as I accidentally hit the enter key after typing the > > > subject. In a spreadsheet I have all of my staff listed by their abbreviated > > > names used to identify them on our server. I want to be able to convert > > > there abbreviated names like "gcarls" to "Carlson, Glen". I think one of the > > > If formualtions will work but I'm having difficulty. Can anyone please tell > > > me how to do this? > > > -- > > > John
From: John on 19 May 2010 12:26 I get raw data from our server - sent by a tech person - the tech person can't provide me more than this - this raw data is sent in an excel spreadsheet. gcarls is one of 13-14 staff memebrs who are idnetified in the raw data by their logon names - for logon to our server and in to a specific custom program where they enter data regarding their activities. I can create a table of these logon names say in col A and their full names in col B - no big problem there. -- John "Mike H" wrote: > John. > > We really do want to help but your not providing sufficient information. > > > gcarls is his logon name in our system and will never change. > > What is 'our system'? > > > I get reports that list things he does by his logon name > > Where are these reports coming from? What is the reporting tool? > > Does 'the system' or 'Excel' have a table somewhere that lists full names > and logon names? If it does you can query that table with a lookup in the way > Eduardo showed you. > > In short, unless you have such a table that is available to Excel then what > your asking can't be done. > > > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "John" wrote: > > > gcarls is his logon name in our system and will never change. I get reports > > that list things he does by his logon name and I want to convert it to his > > full name. > > -- > > John > > > > > > "Mike H" wrote: > > > > > John, > > > > > > How do we establish that gcarls becomes Carlson, Glen? > > > > > > Why for example doesn't that same username become Carlton, Geoff or any > > > other variation? > > > -- > > > Mike > > > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > > introduces the fewest assumptions while still sufficiently answering the > > > question. > > > > > > > > > "John" wrote: > > > > > > > I'll try this again as I accidentally hit the enter key after typing the > > > > subject. In a spreadsheet I have all of my staff listed by their abbreviated > > > > names used to identify them on our server. I want to be able to convert > > > > there abbreviated names like "gcarls" to "Carlson, Glen". I think one of the > > > > If formualtions will work but I'm having difficulty. Can anyone please tell > > > > me how to do this? > > > > -- > > > > John
From: Mike H on 19 May 2010 12:44 John, > I get raw data from our server - sent by a tech person - the tech person > can't provide me more than this - Then it seems as if the 'server' doesn't hold a table of these nsames so you need to create your own in 2 columns in Excel. Col A = Logion name & Col B real name and then this formula =VLOOKUP(C2,A2:B17,2,FALSE) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "John" wrote: > I get raw data from our server - sent by a tech person - the tech person > can't provide me more than this - this raw data is sent in an excel > spreadsheet. gcarls is one of 13-14 staff memebrs who are idnetified in the > raw data by their logon names - for logon to our server and in to a specific > custom program where they enter data regarding their activities. I can > create a table of these logon names say in col A and their full names in col > B - no big problem there. > -- > John > > > "Mike H" wrote: > > > John. > > > > We really do want to help but your not providing sufficient information. > > > > > gcarls is his logon name in our system and will never change. > > > > What is 'our system'? > > > > > I get reports that list things he does by his logon name > > > > Where are these reports coming from? What is the reporting tool? > > > > Does 'the system' or 'Excel' have a table somewhere that lists full names > > and logon names? If it does you can query that table with a lookup in the way > > Eduardo showed you. > > > > In short, unless you have such a table that is available to Excel then what > > your asking can't be done. > > > > > > -- > > Mike > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > introduces the fewest assumptions while still sufficiently answering the > > question. > > > > > > "John" wrote: > > > > > gcarls is his logon name in our system and will never change. I get reports > > > that list things he does by his logon name and I want to convert it to his > > > full name. > > > -- > > > John > > > > > > > > > "Mike H" wrote: > > > > > > > John, > > > > > > > > How do we establish that gcarls becomes Carlson, Glen? > > > > > > > > Why for example doesn't that same username become Carlton, Geoff or any > > > > other variation? > > > > -- > > > > Mike > > > > > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > > > introduces the fewest assumptions while still sufficiently answering the > > > > question. > > > > > > > > > > > > "John" wrote: > > > > > > > > > I'll try this again as I accidentally hit the enter key after typing the > > > > > subject. In a spreadsheet I have all of my staff listed by their abbreviated > > > > > names used to identify them on our server. I want to be able to convert > > > > > there abbreviated names like "gcarls" to "Carlson, Glen". I think one of the > > > > > If formualtions will work but I'm having difficulty. Can anyone please tell > > > > > me how to do this? > > > > > -- > > > > > John
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: converting email address names in a range of cells to real names Next: Excel Code |