D
d'Az
Hi List,
Can anyone help? When concatenating already-concatenated cells, th
result displays perfectly well in the Excel spreadsheet, but truncate
when the cell is pasted into a .txt file. It doesn't seem to be due t
Data Validation limits (having said that, selecting the entir
worksheet and doing Alt > Data > Validation > Validation criteria
Allow = Any value" did seem to solve the problem once, but only to com
back next time round). The truncation occurs sometimes after 8 or 1
chars, and sometimes after 20 or so, always at the same spot. If I cop
the cell into a fresh Excel file, the problem disappears. Does anyon
know what I may be doing wrong? Is it a bug? Any ideas would b
helpful.
Thanks to all,
d'A
Can anyone help? When concatenating already-concatenated cells, th
result displays perfectly well in the Excel spreadsheet, but truncate
when the cell is pasted into a .txt file. It doesn't seem to be due t
Data Validation limits (having said that, selecting the entir
worksheet and doing Alt > Data > Validation > Validation criteria
Allow = Any value" did seem to solve the problem once, but only to com
back next time round). The truncation occurs sometimes after 8 or 1
chars, and sometimes after 20 or so, always at the same spot. If I cop
the cell into a fresh Excel file, the problem disappears. Does anyon
know what I may be doing wrong? Is it a bug? Any ideas would b
helpful.
Thanks to all,
d'A