Is there a shortcut to move all remaining text right of the cursor to the next cell on the right? (Excel 2010)
Is there a shortcut to move all remaining text right of the cursor to the next cell on the right? (Excel 2010)
Do you mean that the cell is active for editing, and you want to move the text to the right of the cursor into the next cell?
No.
This cannot even be done with a macro because a macro can't be activated while a cell is active for editing.
If you explain more about why you want to do this we might be able to offer an overall solution.
That was initially exactly what I was trying to do.
I have a multi page list in the following format:
Item Book Page Notes
XX XX XX XX
XX XX XX XX
The list is in searchable PDF format with no definable columns other than spacing so Select All functions as if within a Word doc.
However, when I paste the selection into Excel I get the following:
The information from 'Item, Book, Page, and Notes' are all pasted into cell 1A, then the second line is pasted into cell 2A, and so on.
Ideally I'm looking to copy/paste and have the information placed as follows:
(Item) into 1A, (Book) into 1B, (Page) into 1C, and (Notes) into 1D, then following with line 2, then 3, and so on.
Another complication is that each entry (Item, Book, etc) can have multiple words.
I expect to have to do some editing but short of manually entering the entire list I am at a loss.
Take a look at Text2Columns - that might get you where you want to be.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Headed in the right direction of what I'm trying to do, but it leaves me at the same point from the other end.
As most of the entries I'm trying to separate have more than one word and this method places each word into a separate cell.
Instead of separating them manually, now I would be condensing them manually. Unless there is an opposite way to do what I was originally trying to do...Is there an easy way to individually condense the data in cells?
The list is in searchable PDF format with no definable columns other than spacingSince each entries is separated by space only & it can have multiple words then Text2Columns method won't work.Another complication is that each entry (Item, Book, etc) can have multiple words.
If we can't find a way to identified how to separate the entries then I'm afraid you need to do it manually.
I suggest:
Copy the data to a text editor, then replace the space beetwen each entries with Tab (manually, one by one) and then copy the result to Excel. The Tab character will separate the data into different column.
Another possibility is to take a look at your actual data & hopefully we can identifity a 'pattern' to separate the entries then use vba to do the job.
If your data isn't a sensitive material, can you post ten rows of your actual data?
The tab method you suggested might be my best option but here are several lines of actual data directly copy/pasted from the PDF file I'm working with.
Dream IncenseUmbra: The Velvet Shadow138
Easy MoneyBook of the Weaver47
Eshtarra's FlowersRage Across the Heavens133
Faerie FoodWerewolf: The Dark Ages121
Faerie FyreFianna Tribebook50
Falcon ArrowsSilver Fangs Tribebook52
Fianna MeadWerewolf Players Guide127
FleshbiterWerewolf: The Dark Ages121
Flood DustNagah101
Gaia's BestFianna Tribebook50
After pasting this here and seeing how a simple text editor views it I'm thinking that the tab method you suggested above would work well. Granted I have several pages to edit in this manor but this is not the first time I have encountered this issue and it certainly will not be the last. Up to this point I have had to manually enter anything in this format I have moved to excel. With the suggestions of text2columns and using tab separations, which I have a feeling is as close as I'm going to get, has made this kind of data entry much easier.
Well, from your data sample I can't find any pattern to separate the entries.
So you need do that manually.
But here's a way to reduce a few keystrokes:
- in the text editor, you don't need to delete the spaces, just add the Tab (between the entries)
- copy the result and paste to a clean sheet cell A1.
- run the code below, it is to trim/delete the extra spaces
Please Login or Register to view this content.
Thank you for the help! It is greatly appreciated!
Thanks to everyone who helped me with this!
You're welcome, glad to help, & thanks for the feedback.
Happy to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks