Excel and comma seperated variables

[Tyn]

Hi Happy Fellas,

Not new to rowing, new to Excel!

I've been searching the forum and some help files but didn't find the answer.

I've got the comma seperated variables file form the pm3,

Q: is there an easy way to put the data in the seperate cells?

Now i've only got the data in line seperate by lots of ','

Soory for being stupid , I think

Regards

[ebolton]

My copy of Excel (which is 97, an old version) reads the C2 CSV files and puts them into cells perfectly and automatically, no troubles. I just open the CSV as if it was a XLS. I am using the card reader rather than connecting direct to the PM3, maybe that makes a difference.

Ed

[Tyn]

Thanks Ed,

I've got the latest excal for mac,
is there an import prefeernce I could set or reset?

Still happy

[PaulS]

After opening the file in Excel, if it does not format automagically:
Select all the data you want formatted, under the "Data" menu item, select "text to columns". You will then get some choices for "delimitted" options.

Have fun.

[Tyn]

Thanks Paul,

I will try 'again'

Happy Konniginnedag!!

[Tyn]

Dear Paul

Excel answers:
Microsoft Excel can convert only one column at a time


What to do?

Still Happy

[tomhz]

Just select the first (=only) column and choose: text to columns.

Tom

[PaulS]

Dear Paul

Excel answers:
Microsoft Excel can convert only one column at a time


What to do?

Still Happy

Okay, maybe I'm misunderstanding what it is you are doing.
If you have a comma seperated file (with line feeds), and copy and paste that into Excel, it fills a number of rows (one for each line of text) and a single coumn (A).

Select column A and then the procedure above to get rid of the commas and place each piece of delimitted text into it's own cell. Seriously, I just did this with a CSV file and it worked like a charm (If I opened the file with Excel directly it seperated into the cells automagically). But it could be a Mac version problem.

[Alissa]

I am definitely not an excel expert, but I just saved some data first as a text file, then opened excel and from "Data" chose "Import External Data", selected "Import Data" then browsed to the text file I had just saved. Excel will tell you that it has found delimited data and ask you what line you want to start the import on (you'll get a Data Preview of what's on what line so that you can tell).

Then just follow through on the rest of the screens...second one requires you to tell it what the delimiters are...yours are commas. If you're not sure, try checking various boxes and see what your Data Preview looks like to find the right combination. In the third one, highlight each column in your Data Preview one by one and select its format and get rid of any extraneous columns.

Everything ends up in its own column, no problems at all.

HTH,

Lisa

[tjod]

I save my *.csv file to the network via wireless from the boathouse. (OK, OK, the garage ... sigh)

When I get back to the bat cave I mean the computer room, I just double-click the .CSV file and Excel opens it - all nicely row and columnized. Using Office 2003, FWIW

Tim O

[BobD]

I save my *.csv file to the network via wireless from the boathouse. (OK, OK, the garage ... sigh)

When I get back to the bat cave I mean the computer room, I just double-click the .CSV file and Excel opens it - all nicely row and columnized. Using Office 2003, FWIW

Tim O

Strange, my Office 2003 just shows jammed up hard to read lines

[Tyn]

Thanks Guys,

I DID it!!


Text to columns worked,
I had to set the delimiters to other and ','

Thanks a lot!!

Happy to Excel