Thread: how to copy first 2 characters only from prior cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default 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?

Reply With QuoteReply With Quote