Copying Cell Content

[Guest]

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.

 

[Chip Pearson]

=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)

 

[Guest]

Chip, You are a life saver. This saves me 2 hours of manual work.

Sincerely,

Keith

 

[Ken Wright]

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
------------------------------­------------------------------­----------------