[Dba-office] Excel - pull data from cell

David McAfee davidmcafee at gmail.com
Thu Jun 2 23:31:19 CDT 2016


If you cant do text to columns,  I'd just make 3 separate cells pull their
data.

I have an example i can send tomorrow from work. I'm  drinking right now
and might not give you the right now :p

Something like =trim(left(A1, find ("/")-1))
On Jun 2, 2016 9:14 PM, "John R Bartow" <jbartow at winhaven.net> 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
>


More information about the Dba-office mailing list