Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy First Character of a cell
I am trying to copy the first character of a cell and combine it with another
row and place it in another row. I am trying to create usernames from two columns First Name and Last Name. I am trying to use Concatenation is this possible. How do I do this? Example: First Name Last Name Username Jim Bob jbob Sally Richards srichards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy First Character of a cell
Assuming your data is in columns a, b and c, the following will create the
Username for you: =lower(left(a3,1)&b3) -- Regards, Fred "kevin_jones01" wrote in message ... I am trying to copy the first character of a cell and combine it with another row and place it in another row. I am trying to create usernames from two columns First Name and Last Name. I am trying to use Concatenation is this possible. How do I do this? Example: First Name Last Name Username Jim Bob jbob Sally Richards srichards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy First Character of a cell
try this
A1 B1 C1 Jim Bob =LEFT(A1,1)&B1 "kevin_jones01" wrote: I am trying to copy the first character of a cell and combine it with another row and place it in another row. I am trying to create usernames from two columns First Name and Last Name. I am trying to use Concatenation is this possible. How do I do this? Example: First Name Last Name Username Jim Bob jbob Sally Richards srichards |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy First Character of a cell
Thank you Mike this is perfect. Is there an easy way to check for
duplicates? and if ther is a duplicate to use the 1st Character + Last Name plus a number? (i.e. jsmith10, jsmith15, jsmith24. I know this is not simple but just thought I would ask. I have to do this 100 more times and I am going to have to manually check for duplicates. Thank you for all of your help. "Mike" wrote: try this A1 B1 C1 Jim Bob =LEFT(A1,1)&B1 "kevin_jones01" wrote: I am trying to copy the first character of a cell and combine it with another row and place it in another row. I am trying to create usernames from two columns First Name and Last Name. I am trying to use Concatenation is this possible. How do I do this? Example: First Name Last Name Username Jim Bob jbob Sally Richards srichards |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy First Character of a cell
Kevin
Freds example will make all user names to lower case if that's what you want you could also change lower to upper to make all user names to be in upper case "kevin_jones06" wrote: Thank you Mike this is perfect. Is there an easy way to check for duplicates? and if ther is a duplicate to use the 1st Character + Last Name plus a number? (i.e. jsmith10, jsmith15, jsmith24. I know this is not simple but just thought I would ask. I have to do this 100 more times and I am going to have to manually check for duplicates. Thank you for all of your help. "Mike" wrote: try this A1 B1 C1 Jim Bob =LEFT(A1,1)&B1 "kevin_jones01" wrote: I am trying to copy the first character of a cell and combine it with another row and place it in another row. I am trying to create usernames from two columns First Name and Last Name. I am trying to use Concatenation is this possible. How do I do this? Example: First Name Last Name Username Jim Bob jbob Sally Richards srichards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Excel 2003 Cell & Character Color and Copy Sound | Excel Discussion (Misc queries) | |||
Change character while copy | Excel Worksheet Functions | |||
Copy partial cell character format(s) from one cell to another - an example | Excel Programming | |||
copy paste cell character limit | Excel Discussion (Misc queries) |