View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Need 2 Copy sentences with commas & paste into one cell.

Hi
- copy your data
- in Excel select a cell, hit F2 and paste the data DIRECTLY in the
formula bar

--
Regards
Frank Kabel
Frankfurt, Germany

"jbaker38" schrieb im Newsbeitrag
...
I am trying to copy text such as sentences with commas, for example:

The big, red, ball rolled down the steep, green hill.

I need the entire sentence to be copied from one screen and pasted

into ONE
cell of my spreadsheet, but it always separates into a different cell

where
ever there is a comma. How can I prevent it from putting it into

different
cells?

Thank you