Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about Formulas
I'm working on a project and was wondering if I could get some help. I
don't have a lot of experience working with formulas in Excel but I hope they provide a solution to what I'm looking to do. I'm trying to create user accounts using a script I have, but I need some help on the Excel side of things. Problem #1: Column A has first names and column B has last names. I'm looking for a formula which would combine the two in a certain way. For example, I need column C to build a username using the first and last name in each row. 'Bill Smith' would become 'Smith_B' in column C. Using one letter from the first name column and an underscore is important. Any ideas or suggestions would be appreciated. Problem #2: This one is probably much easier. In column A I have a series of numbers for each user that's 9 digits long. I need to trim it down to the last 4 digits in each row. For example, 543672891 would be 2891 in the same column. I do appreciate any help someone has to offer. Thank you, Jeff, Cincinnati OH |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about Formulas
#1: =b1&"_"&left(a1,1)
#2: =mod(a1,10000) Cincy Man wrote: I'm working on a project and was wondering if I could get some help. I don't have a lot of experience working with formulas in Excel but I hope they provide a solution to what I'm looking to do. I'm trying to create user accounts using a script I have, but I need some help on the Excel side of things. Problem #1: Column A has first names and column B has last names. I'm looking for a formula which would combine the two in a certain way. For example, I need column C to build a username using the first and last name in each row. 'Bill Smith' would become 'Smith_B' in column C. Using one letter from the first name column and an underscore is important. Any ideas or suggestions would be appreciated. Problem #2: This one is probably much easier. In column A I have a series of numbers for each user that's 9 digits long. I need to trim it down to the last 4 digits in each row. For example, 543672891 would be 2891 in the same column. I do appreciate any help someone has to offer. Thank you, Jeff, Cincinnati OH -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about Formulas
G'day Jeff from Australia,
Both these problem need you to call on the CHARACTER functions i excel. These are workbook functions not macros or VBA For example to get the first letter of Col B and underscore and th Surname to appear in column C Presuming you are on row 2, you would use this formula in cell C2 =B2&"_"&LEFT(A2,1) The second problem is easier. You need only capture the last characters on the right of your referenced cell. Try this; Assuming the number 543672891 is in cell D2 =RIGHT(D2,4) The 4 indicates how many digits from the right you want to read. Pauly -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about Formulas
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on copying formulas | Excel Worksheet Functions | |||
Basic question about what formulas look at. | Excel Worksheet Functions | |||
GENERAL QUESTION - FORMULAS | Excel Discussion (Misc queries) | |||
Freezing Formulas Question 2 | Excel Discussion (Misc queries) | |||
nOOb formulas question | Excel Discussion (Misc queries) |