+ Reply to Thread
Results 1 to 3 of 3

formula to just show numbers?

  1. #1
    Registered User
    Join Date
    07-04-2005
    Posts
    6

    formula to just show numbers?

    Hey all,

    Just a quick one, if c3 displays two digits and then a name how can I make cell a3 automatically display just the digits without have to type it everytime, I'm think I should be able to format with a formula cell a3 to just display the numbers but i'm a bit stuck..

    eg

    cell a3 cell c3
    55 55 bob brown

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    03-15-2005
    Location
    North Carolina
    MS-Off Ver
    2003 & 2007
    Posts
    180
    Try this in A3

    =LEFT(C3,(FIND(" ",C3)-1))
    jtp

  3. #3
    Registered User
    Join Date
    07-04-2005
    Posts
    6
    grand, thanks alot!

+ Reply to Thread

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