answersLogoWhite

0

If you want to take some text from a cell there are a number of functions that can be used. The LEFT function will take an amount of characters that you specify from the left end of a cell. The RIGHT function will do the same thing from the right end. The MID function can take text from the middle of a cell.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is the word for cell in an Excel spreadsheet in spanish?

The word is "celda."


How do I retain Excel cell formatting during mail merge into a table in Word?

Merge brings one to several individual cells from Excel into Word. The formatting in the merged Word document depends on Word, not Excel. If you would like to retain the same formatting as you had in Excel, then format the target location in Word to match the cell from Excel.


What is the size of an Excel sheet?

The max columns on an excel 2007 sheet are 16k. The max rows are 1M. In excel 2003 the max columns are 256 and max rows of 64k.


How do you increase the amount of text allowed in a cell in an Excel spreadsheet?

Increase the width of the column.Format cell allignment for word wrap.


What do you call the sheets in excel?

Normally when you open Excel there are 3 sheets open. They are Sheet1, Sheet2 and Sheet3. Sometimes you will want to give more meaningful names to those sheets. By right clicking on the sheet tab and clicking the Rename option or by double clicking, you can rename a sheet. So you could have many sheets with names on them that are meaningful to what you are doing, which is what we mean by naming sheets.


In excel how do you underline the characters in a cell and not the entire cell?

If this is an Excel question, you can underline words the same as in MS Word - use the 'U' icon or 'Format-font-underline'. The format is called 'underline.'


Where did the insertion point go after you pressed the home key?

In Excel, to the first cell in the current row. in Word, to the start of the current line of text..


How do you link cells in excel so that when one word is input in one cell automatically input in a different cell?

in cell B1 put +A1


Do you need tabs for Excel?

Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.Tabs as in the kind used for positioning text in a word processor are not relevant to spreadsheets. The tab key does other things in a spreadsheet. In terms of sheet tabs, then Excel uses them to identify separate worksheets so they are needed.


How do you automatically paste information from Excel to Word?

There is no automatic method for pasting data from Excel to Word.Open both Word and Excel.Go to Excel and highlight the cell range you want to paste to Word.Copy the range using the method you like.Go to Word and paste the contents at the location you want in Word.Clean up the location and formatting, as you like.


What are the uses of key?

to accept something or in word to start new paragraph.when you press enter in excel you will accept what is inside cell and switch to bottom cell by default


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.