| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to parse column data only when text is present
Hello,
I have just received a CSV file that I've opened in Excel. And in it there is a column that contains values that are text, numeric or both Like: RESTAURANT Or.. 078504877 601-992-5155 Or.. 091649188 EATING PLACES AND REST Is there a way to parse the column ONLY IF it contains any text, into a new column? So for instance, the last set of values above, the values; 091649188 EATING PLACES AND REST would be parsed to column B and C as 091649188 and then EATING PLACES AND REST, respectively. Thanks in advance for your replies. Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| parse text string | Excel Worksheet Functions | |||
| How do I parse one column into different columns? | Excel Discussion (Misc queries) | |||
| Forgotten a Simple Forumla - Is Text present in another column | Excel Discussion (Misc queries) | |||
| SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions | |||
| Parse text & Numbers | Excel Worksheet Functions | |||
Threaded Mode
