Command to move text to new cell

[transact123]

Good Afternoon,

I converted a PDF to an excel Spreadsheet and a lot of text that should be in separate cells is in the same cell. Right now I am using the following method:

Highlight unwanted text in first cell
Ctrl + X
Insert new row
Ctrl + V

and repeating until each cell has the exact information it needs in it. It would be an enormous timesaver if there was a way to be able to click just before or highlight the part of the text that I want to move to the row below and hit a command that automatically moves this text to the row below. Any suggestions?

Thanks!

[ajryan88]

You would need to record it in a macro, and then assign a keyboard shortcut to that macro.

In Excel 2007, you will need to enable the Developer tab (through Excel Options), and then you should be able to see the "Record Macro" button. Press this button, perform the task once, and then press "Stop Recording". You can assign a keyboard shortcut to the macro before you record it.

Hope this helps

[transact123]

Thanks, but there's no clear logic (as far as Excel is considered) when I am making text into a new line. In the line itself, it has name, title, sometimes the company, and sometimes the address. I am separating each of these items manually.

[ajryan88]

Is each piece of text within one cell separated by a space or a comma? Is there some common delimiter? Or is that ambiguous too?

[transact123]

Unfortunately there is no comma delimiter. I tried creating a macro and it wasn't effective. It would just be great if there were a key I could hit to move text to the line below.

[ajryan88]

Without a delimiter (even a space we could work with), I don't think it's a possibility, but it wouldn't be unlike someone with more experience on this forum to come along and prove me wrong

Sorry I couldn't answer your question

[transact123]

Ah, sorry to not be more clear. There are spaces within the name/title/address of the person, I just am not sure how Excel will know when I a person's title ends and when their address begins!

[ajryan88]

Hmmm, I can definitely work with spaces. I will take a look at writing a macro and get back to you soon

EDIT: Ah I actually see the problem now with not all spaces being a delimiter. I'm going back to "I'm not able to solve this one. Sorry"

Good luck though, I hope you get an answer

[transact123]

Thanks for your help! Hopefully Excel can come up with a quick way of moving text to a new cell without having to insert a new line and cut/paste!