cancel
Turn on suggestions
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

how to paste empty cell as empty cell

Danying
Danying
Level II
Created: Oct 20, 2022 04:07 AM  |  Last Modified: Jun 10, 2023 4:55 PM 1828 views

Hi, I want to copy a column with some empty cells and numbers to another new column. But when I pasted it, the empty cells are turn into 0. I cannot delete it one by one because there are many of them. How can I keep the pasted empty cell as it was? Thank you

 

 

 

2022-10-20_16-02-02.png
Preview file
57 KB
0 Kudos
4 REPLIES 4
Craige_Hales
Super User Craige_Hales
Super User


Re: how to paste empty cell as empty cell

Oct 20, 2022 07:36 AM (1811 views)  |  Posted in reply to message from Danying 10-20-2022

It should not do that. We'll probably need more information (unless someone has seen this before!)

 

JMP version?

Win or Mac?

What sequence of clicking/copying/pasting are you using? Mouse? Keyboard?

 

I'd normally do this by selecting entire columns using the headers, then right-click in the selected data (not the header) ->Copy.

Then repeat for the destination (with same number of rows)...select headers, right-click ->Paste.

Craige
jthi
Super User jthi
Super User


Re: how to paste empty cell as empty cell

Oct 20, 2022 07:46 AM (1810 views)  |  Posted in reply to message from Craige_Hales 10-20-2022

Also are there any column properties? Column properties such as Value Labels could possibly cause something like this to happen (have 0 be recoded to . in the column being copied).

-Jarmo
Danying
Danying
Level II


Re: how to paste empty cell as empty cell

Oct 28, 2022 03:14 AM (1774 views)  |  Posted in reply to message from jthi 10-20-2022

Thank you for your reply, jthi.

The data type is "Numeric" and the modeling type is "Continuous". The problem is tentatively solved as I tried again on the other day and I can copy and paste the column exactly what they are. I must miss something that day.

 

Anyway I still appreciate your reply, hope you have a good day:)

0 Kudos
Danying
Danying
Level II


Re: how to paste empty cell as empty cell

Oct 28, 2022 03:07 AM (1774 views)  |  Posted in reply to message from Craige_Hales 10-20-2022

Thank you Craige.

It is JMP version 15.1.0 on Win 10.

I used mouse.

I created a new column with the "Numeric" data type and "Continuous" modeling type. Then I copied the column (with the same column properties) by selecting the whole column and clicking the "Edit"-"Copy with column names". Next I left clicked the new column head to select the column and pasted by choosing "Edit"-"Paste with column names". 

 

I think the problem is tentatively solved because I tried to do it again on the other day and now I can copy and paste the column exactly what they are. I must miss something that day. The original data was copy-paste from the results of the formulated cells in the excel. I don't know whether the formular in the excel would have an influence on this.

 

Thanks again for your reply!

 

 

 

Recommended Articles