Asterix when pasting a column of values from Excel into Minitab (V17)

[DaveZF]

Hi. I have an issue where if I copy a column of values from Excel into Minitab (V17), there is a asterix inserted as a new row in between every value. I have tried formatting etc bit to no avail. Any ideas / experience of this at all? Thx

 

[HH1969]

Hi Dave,
Maybe there are extra spaces after the values?
Can you post the Excel sheet?

Harry

 

[Miner]

Have you tried importing the Excel file directly instead of copy/paste?

 

[optomist1]

I believe the "*" means blank cells or rows....recently transferred .csv (comma separated values) spreadsheet from excel, had to go back and remove the blank rows/cells from sheet then proceed...hope this helps...

 

[Miner]

Minitab uses * to denote a missing value.

 

[DaveZF]

Sorted thanks guys. For some reason (I inherited the worksheet), the whole document was set up with merged cells. So every cell actually contained 2 rows but merged. The * denoted a missing value from the merged cell. Simple when you can see the wood for the trees