How can I separate items from one cell into two?
 

--
bootsy

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


"Bootsy" wrote in message
...

--
bootsy

Peo Sjoblom wrote:

<NOTHING!

http://dts-l.org/goodpost.htm

http://www.netmeister.org/news/learn2quote.html

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

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



Gordon wrote:

Peo Sjoblom wrote:

<NOTHING!

http://dts-l.org/goodpost.htm

http://www.netmeister.org/news/learn2quote.html

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

--

Dave Peterson

Dave Peterson wrote:
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!


--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk