[Dba-office] Excel - pull data from cell

[John R Bartow]

No, blush.

-----Original Message-----
From: Dba-office [mailto:dba-office-bounces at databaseadvisors.com] On Behalf
Of Stuart McLachlan
Sent: Friday, June 03, 2016 8:39 AM
To: dba-office at databaseadvisors.com
Subject: Re: [Dba-office] Excel - pull data from cell

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
> 


_______________________________________________
Dba-office mailing list
Dba-office at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-office