LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default taking characters from last name and first name to create a passwo

I need to create a password based on the first letter of the first name and
the first 3 letters of the last name along with a random number 1-9 at the
end. How can i do this? C1 below is where i want to enter the formula to
create the password.
thanks.

Example:
A1 B1 C1
LN FN New Password
Smith John Jsmi3
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Change link source requiring multiple entry of passwo Glen Miller Excel Worksheet Functions 0 December 4th 09 09:06 AM
Taking specific rows from on workbook to create another workbook Michelle Excel Worksheet Functions 1 May 12th 07 04:54 AM
Taking 10 lefthand characters in a cell keri Excel Programming 2 January 14th 07 12:03 PM
Check for Sheet Password Protected, Unprotect with multiple passwo David Excel Programming 2 June 21st 06 06:19 PM
How can i unprotect a workbook in Excell when I forgot the passwo. Kevin1961 Excel Worksheet Functions 2 October 29th 04 08:58 AM


All times are GMT +1. The time now is 07:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"