+ Post New Thread
Results 1 to 3 of 3
Windows Thread, excel formula help again please in Technical; Im looking for a way to take the first letter of the contents of column A, and combine it with ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199

    excel formula help again please

    Im looking for a way to take the first letter of the contents of column A, and combine it with the contents of column B, to make new contents of column C, with a space between them. Im sure this is possible but I have no idea what it might be called to even start looking.

    Basically its firstname and surname, and im trying to create the usernames from them, so "andrew" "smith" would become "a smith"

    Any excel guru able to give us a tip please?

  2. #2

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,521
    Thank Post
    1,333
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    thanks!!

  3. #3
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    41
    You could also use CONCATENATE which gives a few more options.

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Formula Copy Problem
    By sqdge in forum Office Software
    Replies: 26
    Last Post: 10th February 2013, 06:18 AM
  2. Excel Question / Formula Needed
    By timbo343 in forum How do you do....it?
    Replies: 22
    Last Post: 4th August 2008, 09:06 PM
  3. office for mac excel formula question.
    By russdev in forum Office Software
    Replies: 2
    Last Post: 9th May 2008, 11:51 AM
  4. ICT Budget formula.
    By sLiDeR in forum Budgets and Expenditure
    Replies: 10
    Last Post: 23rd January 2008, 08:14 PM
  5. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM

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
  •