Question about Microsoft Office Standard for PC

1 Answer

Excel sort last four list of telephone numbers

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 11 Answers

In a column adjacent to your data, enter the formula

=RIGHT(A1,4)

and copy down as far as you need to go. Then, sort on that column.

Posted on Feb 25, 2012

Testimonial: "OK spreadsheet use . . . I had hoped for WORD format. I can convert."

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

How can I change my magic jack telephone number?


The MagicJack service allows customers to place and receive phone calls through a computer instead of a traditional phone line. Unlike a landline, MagicJack allows people to select a state and area code for their personal number. Users can also customize a vanity number to make their contact information more memorable. If a customer moves to a new city or would like a different vanity number, he can quickly make this change from the MagicJack website. Step 1 Access your MagicJack online account (see link in the Resources section). Enter the phone number and password associated with the account, and press "Login."
Step 2 Select the "Phone Numbers" menu tab. Click the option labelled "View - Renew - Add." Choose "Add a Phone Number."
Step 3 Choose one of the listed options for the new number. Select "Vanity Number" if you wish to customize your phone number. Standard U.S. and Canadian number options are also available.
Step 4 Check the box marked "I elect to accept free outgoing service." This allows free outgoing calls to phones in the United States. MagicJack must ask this question for legal purposes. If you leave the box unchecked, the MagicJack service will only accept incoming calls.
Step 5 Confirm that you wish to change the MagicJack number. Click "I understand and would like to change my number." Select a state, area code and city for the new number.
Step 6 Press the "I Want to Choose..." button to set the last four digits of the number, or click "No Thanks. I want the last four digits assigned automatically" to receive a random number.
Step 7 Click the "Checkout" button. Fill out the requested payment information to complete the transaction. As of September 2012, the standard fee to change a MagicJack number is $10. Vanity numbers may require an additional fee.

Nov 07, 2014 | Computers & Internet

1 Answer

Uniden cordless phone caller id quit working


Using the Caller ID and Redial Lists
Caller ID (CID) is a service available from your telephone provider that shows the phone number (and sometimes the caller's name) of incoming calls. Contact your telephone provider for more information.
Caller ID list



Redial list



When a call comes in, the phone displays the number and name (if available) of the caller.
The phone saves the information for the last 30 received calls to the

CID list.
When it's in standby, the handset shows how many calls came in since the last time you checked the CID list.


Each handset remembers the last 5 numbers you dialed on it. The redial list is separate for each handset.


- - -

Dec 02, 2012 | Uniden Cordless Phone

1 Answer

How do i unlock my lg 8600 flip


  • Flip open the phone so the keypad is exposed and press any button to wake the phone up from sleep mode.
  • 2 Enter the four digit unlock code using the phone's keypad. The default code is the last four digits of your cell phone number.
  • 3 Press the "OK" button to submit the code and unlock the phone.
Forgotten Code
  • 1 Turn the phone over and remove the battery cover and battery. Press down on the upper plastic edge of the cover and slide it in a downwards motion. The plastic cover will give way to the battery which can be pulled out of the phone.
  • 2 Locate the sticker on the phone hidden behind the battery. Write down the last four digits of the ESN DEC number.
  • 3 Replace the battery and battery cover and turn the phone on by pressing and holding down the "Power" button.
  • 4 Flip open the phone so the keypad is exposed.
  • 5 Enter the last four digits of the ESN DEC number. Press the "OK" button to submit the code and unlock the phone.
Power the phone on and select the "OK" button. This will trigger the phone to ask for the password.

  • 2 Press "OK." Sometimes this is simply all it requires. If not, move on.
  • 3 Enter the last four digits of the phone's number. If this doesn't work, continue to the next step.
  • 4 Enter "#4357" or "*4357." "4357" stands for "LOCK" on a traditional telephone's alphabetic keypad translation. This is the default unlock code for certain LG telephones.
  • Dec 06, 2011 | LG Cell Phones

    1 Answer

    I blocked a telephone number by mistake. How do I unblock it? Thanks


    Hi ther here is some steps if it works..Enter the last four digits of your phone number on your cell phone PIN screen.
    Enter 9999, and if that doesn't work try 1111, and if that doesn't work try other four-digit numbers you may have entered.
    Shut off your cell phone, take off the back of your phone and pull out the battery. Record the IMEI number which is under the battery. Re-insert the battery and power on the phone. Enter the last four digits of the IMEI number on the PIN entry screen
    Call your service provider and request the unlock PIN if none of your attempts so far have worked. You will have to prove you are a customer by stating your cell phone number..
    Finally See a cellphone technician..

    Jun 19, 2011 | Uniden Cell Phones

    1 Answer

    I have Microsoft Office 2007 which I purchased from Dell and installed late last year or earlier this year, however, the Excel keeps getting lost and I cannot open documents which I have done or received...


    Use http://www.magicaljellybean.com/keyfinder/ to find the serial number. As for the corrupt Excel program, you may need to determine what exactly is the problem there.

    Go to Start, All Programs, Microsoft Office and see if Excel is listed. If it is, then click on it to launch it. Does it open? If so, then go to where your excel spreadsheets are saved to (e.g. My Documents) then right click an Excel spreadsheet & click on "Open With". Select Choose Program. Select the Microsoft Excel. If Excel is not listed, click the browse button and browse to C:\Program Files\Microsoft Office\Office12. Click the Always use the selected program to open this type of file checkbox. Click OK

    Nov 26, 2010 | Microsoft Windows XP Professional

    1 Answer

    I forgot my security code on my phone how do i get 2 change or reset it when i am locked out?


    I'm sorry to hear you are locked out of your cellular telephone. I will try to help you with this.

    You didn't mention the make of your telephone nor your service provider.

    Often, the default security code for a cellular telephone, the code that keeps the average person from using your telephone without your permission, is the last four digits of your telephone. Hopefully, you didn't elect to customize this number. If you did enter a different number, you may have to call your service provider. Try all the kids birthday anniversary or your house number before you call them.

    I hope this works for you and you are able to use your telephone again.

    Thanks for posting your question on FixYa.com

    a

    Nov 04, 2009 | Computers & Internet

    1 Answer

    I want my friend cell number who is in Francis Xavier's Convent which is in bellary cowl bazaar , but she is not ready to give her number , but I want it very urgently so...


    Hi

    Im so sorry but that is not possible, cellphone numbers are not distributed by telephone companies for the security of the owner. And chances are cellphone numbers are not listed in a directory for these places, you can get always look up int web the country code and area code but then you will have to do a wild guess for the last four digit number and chances are slim....

    hope you understand. Thanks for using Fixya....

    May 10, 2009 | Samsung SGH-J600 Cellular Phone

    2 Answers

    Lock code needed when erasing all contacts on sch-u740 cell phone


    it's the last four numbers of the telephone number for that phone .. , it's the last 4 digits of the phone number that it had when it came to you

    Mar 10, 2009 | Samsung SCH-u740 Cellular Phone

    2 Answers

    DIRECT TV BOX SIGNAL LIGHT JUST BLINKS BLUE


    [ http://www.directv.com/DTVAPP/global/contentPageNR.jsp?assetId=3460052 ] Please copy this web page link and paste it into the address bar of your web browser. It will take you to the Direct Tv troubleshooting page. On this page you will find a list of problems with solutions. You will also find a list of extensions in the list. The extensions are also troubleshooting problems that you can sort through and find the problems that is most like the problem you are having. There are suggestions for solving the problems and telephone numbers to help you, if you cannot solve the problem yourself. I am sure you will find help with your problem on this page. Thank you for using FixYa and have a nice day.

    Mar 03, 2009 | RCA DIRECTV Satellite Remote Control

    1 Answer

    Sorting within a column


    This page covers how to manipulate columns when the data is formatted as "LastName, FirstName MiddleName"... I'm guessing you could just tweak it:
    http://www.cpearson.com/excel/FirstLast.htm

    This google group goes more in depth on the topic:
    http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/49bf87ffdc31a9d3/954544ded2b2f620#954544ded2b2f620

    Jan 04, 2008 | Computers & Internet

    Not finding what you are looking for?
    Microsoft Office Standard for PC Logo

    63 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2658 Answers

    Piyal Perera
    Piyal Perera

    Level 3 Expert

    528 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18389 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...