Different data within cell

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Thu Feb 23, 2017 1:06 am

Different data within cell

Postby baifulang » Thu Feb 23, 2017 1:14 am

I'm totally new to SPSS and need to create frequency reports for a set of data in Excel which contains different variables within cells, that is, text values separated by periods (full stops). Example:
1) "Spain" "Cinema. Subtitles. Dubbing."
2) "France" "Dubbing. Research."
I want to count for example all items that include "Dubbing" in that field and then create frequency reports and graphs, but I really can't find the way to do it. I don't even know how this function is named, so I cannot look it up in the forum, sorry.
Posts: 2699
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Re: Different data within cell

Postby statman » Thu Feb 23, 2017 1:24 pm

Have you imported it into SPSS?

If not then when you do part of the import will allow you to define the field entry format whereby you might be able to split out the field but ...........
See the note below

NOTE: Please read the Posting Guidelines and always tell us your OS, the SPSS version and information about your study and data!

Statistical Services

Who is online

Users browsing this forum: No registered users and 1 guest