M
Marion Jakob
hi
i would like to paste text via clipboard into a merged cell in excel.
let's say i merged cells A,B and C. if i copy the word "test" from
notepad and paste it into this merged cell excel doesn't accept it.
so i wrote "test" into the merged cell and pasted it into notepad. in
notepad appeard "test" followed by 2 tabs (the two tabs are because i
merged 3 cells).
i thaught i found the solution and copied "test" folowed by 2 tabs
from notepad into the merged cell.
excel accepts it but it splits the merged cells!
is there a way to paste text from a text editor into merged cells
without splitting them?
i think the best would be not working with merged cells but i didn't
desing the sheets by myself and i would not like to change all the
sheets.
thanks for your help
i would like to paste text via clipboard into a merged cell in excel.
let's say i merged cells A,B and C. if i copy the word "test" from
notepad and paste it into this merged cell excel doesn't accept it.
so i wrote "test" into the merged cell and pasted it into notepad. in
notepad appeard "test" followed by 2 tabs (the two tabs are because i
merged 3 cells).
i thaught i found the solution and copied "test" folowed by 2 tabs
from notepad into the merged cell.
excel accepts it but it splits the merged cells!
is there a way to paste text from a text editor into merged cells
without splitting them?
i think the best would be not working with merged cells but i didn't
desing the sheets by myself and i would not like to change all the
sheets.
thanks for your help