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

#1
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
 
Elsmar Forum Sponsor

optomist1

A Sea of Statistics
Trusted Information Resource
#4
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...
 
#6
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 :)
 
Thread starter Similar threads Forum Replies Date
D Pasting table on OASIS new database AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 0
Sidney Vianna Cutting & Pasting via Google Chrome - hyperlinks are lost After Work and Weekend Discussion Topics 5
A PFMEA - How long should the recommended actions remain in the recommended actions column? APQP and PPAP 3
S How to fulfill PFMEA "requirement" column? FMEA and Control Plans 2
S FMEA column column ''therblig motion'' for a given potential failure FMEA and Control Plans 12
A Corrective Action Column in Control Plan and aligning PFD, PFMEA and Control Plan FMEA and Control Plans 6
J Macro Question: Get Column Name by Column Number / or Use Text constant to link on a Using Minitab Software 1
Z Adding 1% error to data in a column in Minitab Using Minitab Software 3
R Is it possible to randomly select samples from 1 column to many column Using Minitab Software 2
O Importing Data via Script - Assign Column as Text (Minitab) Using Minitab Software 3
M Shewhart Control Chart for SPC In Excel - Explain the yellow and red marked column Statistical Analysis Tools, Techniques and SPC 2
W 'Classification' column in DFMEA FMEA and Control Plans 3
Proud Liberal Is there a way to import Column Descriptions in Minitab? Using Minitab Software 4
E Content of Column 18 of the Control Plan FMEA and Control Plans 1
T PFMEA (Process FMEA) Recommended Actions Column FMEA and Control Plans 10
bobdoering Measurement Expert Advice - Modern Machine Shop Magazine Column General Measurement Device and Calibration Topics 0
A Minitab ANOVA Error Message - *ERROR* No data in column. Using Minitab Software 3
M Insert Empty Column Using Minitab Macro Using Minitab Software 2
B How to copy rows to another worksheet based on the contents of a column Excel .xls Spreadsheet Templates and Tools 6
smryan How to get data (column varies) from one sheet to another? Excel .xls Spreadsheet Templates and Tools 12
C Control Plans - Evaluation Measurement Technique Column - Torque Control FMEA and Control Plans 2
Z Subsetting based on values in a text column in Minitab Using Minitab Software 1
P SMED - Single Minute Exchange of Dies template (tabular column) wanted Lean in Manufacturing and Service Industries 8
T Minitab - Getting a Minitab Macro to look up a Column Name Using Minitab Software 23
M Minitab Macro-Command 'NUMERIC' to convert a text column to an numeric column Using Minitab Software 8
S Seeking suppliers with robotic welding capability for Steering Column manufacturing Supplier Quality Assurance and other Supplier Issues 3
P A collection of Dr. Wheeler's Articles from SPC Toolkit column of Quality Digest Statistical Analysis Tools, Techniques and SPC 3
C Minitab Column Sorting Issue - Invalid variable(s) to sort Using Minitab Software 9
Q FMEA Cost Column added to Associate and Prioritize Risks according to Cost FMEA and Control Plans 10
M MiniTab Calculated Formulas for a Calculation in a Column Using Minitab Software 4
P Counting the occurences of a value in a column - Minitab student release 12 Using Minitab Software 4
D What is the Control Plan Characteristic Class column? FMEA and Control Plans 11
D FMEA and Control Plan Characteristics Column - Product / Process Information FMEA and Control Plans 2
A Classification column - PFMEA - Customer doesn't identify any critical characteristic FMEA and Control Plans 16
B What are your inputs for the "Process function / Requirements" column FMEA and Control Plans 6
T Recommended Action(s) Column - Process FMEA FMEA and Control Plans 17
J Poka-Yoke in Process FMEA (PFMEA) - Which column? FMEA and Control Plans 10
M Need excel formating help - Have excel automatically populate a column Excel .xls Spreadsheet Templates and Tools 19
A FMEA recommended actions column - What to do after actions are complete? FMEA and Control Plans 15
S TS 16949:2002 - Error Proofing Column Required in Control Plan II FMEA and Control Plans 22

Similar threads

Top Bottom