copy from one cell to another

Microsoft Excel 2003 (full product)
August 19, 2010 at 12:25:27
Specs: Windows XP
I am needing to copy the first two characters from one cell to another. What is the easiest way to do this with out copy/paste multiple times?

See More: copy from one cell to another

Report •

#1
August 19, 2010 at 12:32:16
If your text string is in cell A1 then in B1 put:

=LEFT(A1,2)

MIKE

http://www.skeptic.com/


Report •

#2
August 19, 2010 at 12:41:45
kUHL...THANKS!

Report •

#3
August 19, 2010 at 14:39:50
Glad I could help.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question