Thread
:
Question about Formulas
View Single Post
#
4
Posted to microsoft.public.excel.programming
Cincy Man
external usenet poster
Posts: 2
Question about Formulas
Thank you very much for your help, both of you!
Jeff, Cincinnati OH
(Cincy Man) wrote in message . com...
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
Reply With Quote
Cincy Man
View Public Profile
Find all posts by Cincy Man