0
Text functions are the answer. I am not clear if you mean that you wish to trim some trailing spaces [See =TRIM()], or if you know how many 'last characters' you need to 'cut', in which case you would need to discover the length [See =LEN()] and then obtain the left most characters [=LEFT()] using the length - the number of characters you are looking to cut. If this is a one off, you could use Data / Text to columns. Regards, Stuart Tayler
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Which short cut key is used to select the top leftmost cell of the Excel sheet?
Ctrl-Home will bring you to cell A1 in a worksheet in Excel.
How can you drag an Excel cell without mouse or in keyboard?
You can not use the keyboard to drag in Excel, but you can use cut and paste. Go to the starting cell and press Crtl-X to cut, then use the arrow keys to move to the cell where you would like to move the contents of the first cell and press Crtl-V.
What is the easiest process to copy and move it to another cell in excel?
CTRL-X to cut, CTRL-V to paste is probably the most reliable.
When using in cell editing a character or adjacent characters you can use the mouse to drag through the characters and then press the delete key or click the cut button on the standard toolbar?
True
In Excel when you cut text does it move to the clipboard?
Yes it does.
Who are the main characters in the book Cut?
The main characters in the book Cut by Patricia McCormick are:CallieAmandaBeccaTaraDebbieSydneyTiffanyYou (the psychiatrist)
How do you import data from word to Excel?
You do not really import data from Word, but you can cut and paste from Word to Excel. If you like, you can embed the word document in an Excel worksheet.
What is a receiver cell in Microsoft Excel?
There is no specific term "receiver cell" associated with Excel. Within an individual spreadsheet a user may have cells which hold information about receivers of one kind or another, like a telephone receiver or audio receiver or data receiver, and they may enter something into it. This is like you could have an "Age cell" or a "country cell" or a "gender cell" to hold information about things relating to ages, countries or genders on a particular spreadsheet. What you may be referring to is a cell that receives something that has been copied or cut. The proper term for that is a destination cell.
Command used to cut a cell?
Cut could be interpreted in different ways. The cut command will cut in a cell in terms of removing data to put it somewhere else. A merged cell can be split by using the split command. It is also possible to cut data from data in a cell using some of the text functions like MID().
What is trim in excel?
It allows you to cut out unwanted space around a piece of text. That way you are just left with the actual characters that make up the text with no spaces at the beginning or the end, although spaces in the middle will be kept where you have more than one word.
How many cut or copied items can be stored in the Office Clipboard for an Excel worksheet?
24
Command used to cut a cell or a range of cells?
cut command
