| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
parsing words in a cell separated by commas
does any one know how to loop thru and extract words in a cell separated
by commas? the number of words will change and they will need to be trimmed (and pasted into other cells). any help will be greatly appreciated. --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
parsing words in a cell separated by commas
That sounds like a CSV file (comma delimited).
Paste the data into notepad and save the file with the extension .csv Excel will do the rest for you when you open it. "spjoseph0511" wrote in message ... does any one know how to loop thru and extract words in a cell separated by commas? the number of words will change and they will need to be trimmed (and pasted into other cells). any help will be greatly appreciated. --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
parsing words in a cell separated by commas
if the strings are in one column, try use Text to Columns under the data
menu. -- Regards, Tom Ogilvy "spjoseph0511" wrote in message ... does any one know how to loop thru and extract words in a cell separated by commas? the number of words will change and they will need to be trimmed (and pasted into other cells). any help will be greatly appreciated. --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort data separated by commas | Excel Worksheet Functions | |||
| Compare two files and update data from another file base on words ina cell separated by commas | Excel Worksheet Functions | |||
| Reversing the order of data separated by commas within a cell? | Excel Discussion (Misc queries) | |||
| How do I de-concatenate items separated by commas! | Excel Discussion (Misc queries) | |||
| MSExcel--words in a cell separated by comma need to be moved into. | Excel Worksheet Functions | |||
![spjoseph0511[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
