Results 1 to 3 of 3

Formula to manipulate text

Threaded View

  1. #1
    Forum Contributor Dave H9's Avatar
    Join Date
    03-10-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    418

    Formula to manipulate text

    Simple one for you guys I'm sure -

    What formula do I use to extract cell info as below

    Cell A1 contains (as text) "User.Name"

    I want formula in cell B2 to return "UN"

    ie first letter and first letter after "."

    Thank you in advance.

    Dave H
    Last edited by Dave H9; 05-11-2011 at 06:55 AM.

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1