Discussion on:
View:
Show:
I have not previously used this feature, although I use "Table to Text" often in MS Word. Also it helps that you pointed out that more than one condition of separating data can be chosen in the dialog box.
I use this procedure a lot. It's great for working with mixed lists of data. There are also ways to reverse the process by using the concatenate formula.
Select Data, Text to Columns
Please mention Libre and Open Office whenever there is a shared function with Excel!
Please mention Libre and Open Office whenever there is a shared function with Excel!
Excellent tip! Thanks for posting.
dp
dp
I use to save the foreign data as txt with notepad, and then load the txt in excel and parse the fields in columns.
This is faster because it allows you to choose more than one field separator and you don't have to create temp files.
Nice! Thank you.
This is faster because it allows you to choose more than one field separator and you don't have to create temp files.
Nice! Thank you.
wow, it's a sad state of affairs when we need a lesson to watch a MS preview pane. Best point is that you can pick more than one delimiter. Thanks for that tip. Does 2010 take it further?
I don't think the feature's been improved in 2010 -- could be wrong, but have noticed anything new. I don't think it's sad though -- this feature isn't used near as much as it should, and it's more powerful than folks realize -- just letting people know. A lot of users never really have the time to learn how to use these apps efficiently -- that's where I come in. 
Thanks! A useful little tidbit for those who weren't aware of it.
Personally, I've been using text-to-columns for years to parse data I've exported from other programs - usually lists of full-path filenames. The fun part was when I finally broke down and upgraded from 2000 to 2010 and had to figure out where the feature was relocated in the ribbon bar
I'm surprised, however, that you didn't extend the lesson to include all the pages of the feature. Like where you can format the data, or choose to skip a column of data entirely, so you don't have to mess around deleting columns later.
Personally, I've been using text-to-columns for years to parse data I've exported from other programs - usually lists of full-path filenames. The fun part was when I finally broke down and upgraded from 2000 to 2010 and had to figure out where the feature was relocated in the ribbon bar
I'm surprised, however, that you didn't extend the lesson to include all the pages of the feature. Like where you can format the data, or choose to skip a column of data entirely, so you don't have to mess around deleting columns later.
Great article about an incredibly useful feature. I've been using the feature for a bit where I have multiple rows in a single cell that have been created using the keystroke combination ALT/ENTER to go to a new row. It turns out that keystroke combo inserts the ASCII CR (Carriage Return)character.
You can enter the CR character as your delimter with ALT 010.
You can enter the CR character as your delimter with ALT 010.
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
