how to copy first 2 characters only from prior cell
 

I need to take the string of characters from one cell and split it into 3
separate cells. Is there a formula that can accomplish this?

how to copy first 2 characters only from prior cell
 

You could use datatext to columnsfixed
or
=left(a1,2)
or mid(a1,1,2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jsm1th" wrote in message
...
I need to take the string of characters from one cell and split it into 3
separate cells. Is there a formula that can accomplish this?