+ Post New Thread
Results 1 to 3 of 3
How do you do....it? Thread, Help with spreadsheet formula... in Technical; Hi, I'm using the following formula to generate user names in Excel: =LEFT(A1,100) & B1 Forname in A1 and surname ...
  1. #1

    Join Date
    Jun 2006
    Location
    Manchester
    Posts
    58
    Thank Post
    8
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Help with spreadsheet formula...

    Hi, I'm using the following formula to generate user names in Excel:

    =LEFT(A1,100) & B1

    Forname in A1 and surname in B1

    this is producing JoeBloggs: what I want is JoeB.

    Any ideas how I can amend the formula so it extracts only the first letter of the surname?
    Thanks

  2. #2
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    593
    Thank Post
    46
    Thanked 166 Times in 104 Posts
    Rep Power
    79
    =A1&left(B1,1)

    Currently your formula is producing the first 100 leftmost characters in A1 and all of B1. The formula above will give all of A1 and the leftmost character in B1

  3. Thanks to clareq from:

    markesmith (22nd November 2010)

  4. #3
    Devontechie's Avatar
    Join Date
    Nov 2007
    Location
    UK
    Posts
    876
    Thank Post
    168
    Thanked 188 Times in 152 Posts
    Rep Power
    69
    try this....

    =CONCATENATE(A1,LEFT(B1,1))

  5. Thanks to Devontechie from:

    markesmith (22nd November 2010)

SHARE:
+ Post New Thread

Similar Threads

  1. Spreadsheet to Blackberry (or other device)
    By Cache in forum Netbooks, PDA and Phones
    Replies: 2
    Last Post: 3rd March 2010, 07:17 PM
  2. Anyone got a printer cost spreadsheet
    By SimpleSi in forum General Chat
    Replies: 5
    Last Post: 7th February 2010, 06:21 AM
  3. Account Management Spreadsheet
    By cookie_monster in forum Windows Server 2008
    Replies: 0
    Last Post: 13th May 2009, 02:05 PM
  4. [Website] Job Predictor Spreadsheet
    By DaveP in forum Jokes/Interweb Things
    Replies: 5
    Last Post: 14th September 2008, 10:17 PM
  5. google spreadsheet
    By russdev in forum Educational Software
    Replies: 15
    Last Post: 15th June 2006, 06:42 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •