breaking text into multiple cells

D

Dwade01

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Lets say I type "a b c d" into a cell. Is there a way I can place the cursor between "a" and "b" and then cause only "a" to remain in the original cell while "b c d" move to a new cell?

Thanks!
 
G

Guest

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel Lets say I type "a b c d" into a cell. Is there a way I can place
the cursor between "a" and "b" and then cause only "a" to remain in the
original cell while "b c d" move to a new cell?

Thanks!

Do you mean other than drag to the right and Cut, and then paste nto a
new cell? If you always want the characters after the first character,
you can do it with a formula. If you want something activated based on
the cursor locatin, you can't even do that in VBA (if VBA were present).
 
C

CyberTaz

"Let's say" you disclose exactly what the data is & what you specifically
need to do with it rather than this hypothetical example :) Perhaps there
possible ways to get it done, but it depends on a number of factors. Based
on what you've disclosed, BobG is correct. There is no option for causing
cell content - in whole or in part - to arbitrarily jump to another cell.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
D

Dwade01

Haha, I'm grabbing list of animals off of pdfs and placing them in excel cells. What's happening is the lists paste into one cell instead of multiple cells. So I was hoping to learn a way to rapidly place each animal species into its own cell.

I'll be more specific next time!
 
C

CyberTaz

Well, that may make all the difference in the world -- what you're now
describing is actually quite different from your first example.

Try using Data> Text to Columns. Depending on further specifics about these
'lists' & how the items actually are separated it may just do the trick.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
D

Dwade01

Thanks that worked great at first. I copied a paragraph of animals names separated by comas and used Data>Text to Columns to pasted each animal species into a separate cell along one row. Exactly what I wanted. But then some how Excel started pasting the species to multiple rows instead of just one. Can you help me out?
 

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

Top