how to copy first 2 characters only from prior cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You could use data>text to columns>fixed
or
=left(a1,2)
or mid(a1,1,2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro that will insert a simple text string in top cell of text file 1
VBA set thick borders around non empty cells in range 0
Separating parts of a string in VBA 4
No characters data in Hyperlink cell 3
Macro that splits content from cell if given character is found 4
First 3 characters 5
How make long string in a cell become text line by line in same cell? 4
Splitting Paragraph into two columns w/limit of 256 characters 4

Back
Top