| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Cell Content
Does anyone know how to copy only certain characters from cell to cell? For
instance, I am trying to copy the first 10 characters from a cell to a new cell. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Cell Content
=LEFT(A1,10)
will return the 10 left-most characters in cell A1. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Novice" <Novice @discussions.microsoft.com wrote in message ... Does anyone know how to copy only certain characters from cell to cell? For instance, I am trying to copy the first 10 characters from a cell to a new cell. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Cell Content
Chip, You are a life saver. This saves me 2 hours of manual work.
Sincerely, Keith "Chip Pearson" wrote: =LEFT(A1,10) will return the 10 left-most characters in cell A1. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Novice" <Novice @discussions.microsoft.com wrote in message ... Does anyone know how to copy only certain characters from cell to cell? For instance, I am trying to copy the first 10 characters from a cell to a new cell. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Cell Content
The other option is to copy the entire column to the new column, and then
use Data / Text to Columns on the new column with the Fixed Width option, setting a break at the 10th character. This will split your data into 2 columns, the first being 10 characters wide and containing the first 10 characters of every cell, and the second column having the rest. Then just select the second column and choose the option "Do not import" on that column. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Novice" wrote in message ... Chip, You are a life saver. This saves me 2 hours of manual work. Sincerely, Keith "Chip Pearson" wrote: =LEFT(A1,10) will return the 10 left-most characters in cell A1. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Novice" <Novice @discussions.microsoft.com wrote in message ... Does anyone know how to copy only certain characters from cell to cell? For instance, I am trying to copy the first 10 characters from a cell to a new cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Copying worksheets into one workbook... based on content | Excel Discussion (Misc queries) | |||
| copying content of cell automatically to multiple cells | Excel Worksheet Functions | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
![Novice[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
