breaking text into multiple cells

[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!

 

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

 

[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

 

[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!

 

[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

 

[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?