[Dba-office] Excel - pull data from cell

[Stuart McLachlan]

Am I missing something?  That sounds like a standard Text To Column operation.

Select all the rows in the 4th Column
Select Data - Text to Columns
Choose Delimited
For the delimiter select"Other" and type in the slash.


On 2 Jun 2016 at 23:13, John R Bartow wrote:

> Hi All,
> Another Excel question, I need to extrapolate the data in one cell
> into separate cells. I have 3460 rows of data, of which the first 4
> columns data are all nicely pertaining to their column header and the
> fifth column which is data clumped together and formatted like this:
> Details WinHaven LLC / Prep / DESKTOP-CUV27BK - Agent version update:
> Do not update
> 
> Why they just didn't separate the 3 pieces into 3 columns (it's a .csv
> dump from a database) I will never know, the company just got bought
> out so I will never get them to make any customizations now! 
> 
> I need to extrapolate that data into one column for each data between
> the /
> 
> Any ideas?
> 
> TIA 
> John B
> 
> _______________________________________________
> Dba-office mailing list
> Dba-office at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-office
>