How can I separate items from one cell into two?

J

JulieD

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
 
D

Dave Peterson

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.)
 
G

Gordon

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.)
Click to expand...
But perpetuating the "crime" is not a solution, especially when he
doesn't point out to the OP the error of his ways!
 
Top