How can I separate items from one cell into two?

  • Thread starter Thread starter Guest
  • Start date Start date
here's two ideas
1) use data / text to columns
2) use a formula such as =LEFT(A1,3) or =RIGHT(A1,4)

if you'ld like more assistance please post back with additional details and
type out two or three examples of your data.

Cheers
JulieD
 
This is Peo's way of answering posts that have the question in the subject (and
nothing in the body).

Peo "Mahatma" Sjoblom

Master of civil disobedience.

(He dislikes it at least as much as you.)
 
Dave said:
This is Peo's way of answering posts that have the question in the subject (and
nothing in the body).

Peo "Mahatma" Sjoblom

Master of civil disobedience.

(He dislikes it at least as much as you.)
But perpetuating the "crime" is not a solution, especially when he
doesn't point out to the OP the error of his ways!
 

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

Back
Top