In Excel 2010
I pasted data from another source that was Comma separated values (not a CSV FILE)
I then did the DATA / Text to Columns function; using Delimited, on Commas
that worked fine.
I then inserted a column and pasted a simple formula =IF(G2>0,LEFT(G2,6),"") <-- Note this has 3 commas in it..
When I click into a cell and paste the formula, it breaks into 4 parts [=IF(G2>0] [LEFT(G2] [6)] ["")]
And spreads across 4 cells (overwriting the data in the other cells.
It works OK, if instead of pasting the formula directly into the cell, I past it into the formula bar.
But I have to do this a lot and invariable forget.
This ONLY happens in workbooks that I first parsed on commas.
Is there a way to fix that?
I pasted data from another source that was Comma separated values (not a CSV FILE)
I then did the DATA / Text to Columns function; using Delimited, on Commas
that worked fine.
I then inserted a column and pasted a simple formula =IF(G2>0,LEFT(G2,6),"") <-- Note this has 3 commas in it..
When I click into a cell and paste the formula, it breaks into 4 parts [=IF(G2>0] [LEFT(G2] [6)] ["")]
And spreads across 4 cells (overwriting the data in the other cells.
It works OK, if instead of pasting the formula directly into the cell, I past it into the formula bar.
But I have to do this a lot and invariable forget.
This ONLY happens in workbooks that I first parsed on commas.
Is there a way to fix that?