#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