microsoft excel
When I am copying partial text from one cell and pasting into another what I am pasting is separating into multiple cells.
Example:
Copying "June 15th" from a cell containing "Little Timmy's Birthday is June 15th", it pastes into two cells "June" and "15th".
Could there be a setting I have inadvertently changed? I have used the text to columns feature this morning splitting by space in another workbook, but I don't know why that may have carried over to when I use a simple Ctrl+C and Ctrl+V.
I agree with Excellll; you're going to need VBA to convert the values in place to a string value.
This method won't result to text strings; but it might help you get the format you need.
Let's say these were my minutes:
Type 1440 into any blank cell. Select this cell and press Ctrl + C.
Select the range that contains the minutes.
Paste Special > Values > Divide
Click OK. Result:
Select the range of number again and press Ctrl + 1.
Go to Number > Custom
Type the format:
[h] "h" mm "m"
Result:
If you'd like to change them back to minutes:
1440 into any blank cell. Select this cell and press Ctrl + C.To get the number of hours in decimal form, use 60 instead of 1440. So for 330 (mins), you'll get 5.5 (hours).
If you've used Text to columns recently, it will apply those settings to the Paste operation. I don't remember this happening before Excel 2007, but it may have. I always have to go back and set it back to tab delimited before I start copying and pasting again.
Best Answer
If you have a text string copied that you want to appear in a single cell, then select that cell and change to Edit mode, then paste your clipboard.
There are a few ways to enter Edit mode e.g. double click the cell, hit F2 key etc. It's described in detail here:
http://office.microsoft.com/en-au/excel-help/edit-cell-contents-HP001216389.aspx
Using that approach, there is no way for your paste to spread to another cell, regardless of Text to Columns settings.