You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I have a value of 610-05-10-00001 in cell A and would like 610051000001 (dashes removed) to be the pasted result in cell B. Is there a copy and paste function that will make this change when pasting, OR is there format that I can apply to cell B that will strip out the dashes once the values are copied into cell B?
MacBook Pro 17″, OS X 10.10
Not copy/paste but if you have a column of these values you want to convert, you can use a formula and later replace the formula with its value
If your dashed values are in column A, use the formula =SUBSTITUTE(A,"-","") in the adjacent cells in column B. Next, if desired, select all those cells with formulas, Copy, and use the menu item Edit->Paste Values to replace the formulas with their results.
Not copy/paste but if you have a column of these values you want to convert, you can use a formula and later replace the formula with its value
If your dashed values are in column A, use the formula =SUBSTITUTE(A,"-","") in the adjacent cells in column B. Next, if desired, select all those cells with formulas, Copy, and use the menu item Edit->Paste Values to replace the formulas with their results.
A 'number' containing three hyphens is actually a text string. The SUBSTITUTE function here replaces the hyphens with null strings ( "" ).
The result is a text string containing only the numerals.
Regards,
Barry
oops! Neglected to refresh this page or scroll down for previous replies. I see Badunit has already provided essentially the same answer.
B
Numbers copy cell value and paste with edit
