| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy selected part number of text from one cell into another cell
Hi
Can anyone help me. I have a database where a cell has text or numbers (example Cell: B1: contains company name : excel corporation 2008 Limited I need to copy the first 4 characters in cell B1: into A1: EXCE I also need the text to be in uppercase in A1 even when lowercase in B1. Assume I need to change the number of characters copied over from 4 to 2 or 6. How would the formula change? If the excel sheet I was working on had 1000 rows of data, would I just drag the formula down from A1 to A100? Any suggestions will be greatly appreciated. -- David |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy selected part number of text from one cell into another cell
=UPPER(LEFT(D2,4))
-- Don Guillett Microsoft MVP Excel SalesAid Software "orewa" wrote in message ... Hi Can anyone help me. I have a database where a cell has text or numbers (example Cell: B1: contains company name : excel corporation 2008 Limited I need to copy the first 4 characters in cell B1: into A1: EXCE I also need the text to be in uppercase in A1 even when lowercase in B1. Assume I need to change the number of characters copied over from 4 to 2 or 6. How would the formula change? If the excel sheet I was working on had 1000 rows of data, would I just drag the formula down from A1 to A100? Any suggestions will be greatly appreciated. -- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy a number into a text cell, keeping leading zeros? | Charts and Charting in Excel | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
| how to count the number of text frequencies and copy to other cell | Excel Worksheet Functions | |||
Hybrid Mode
