Hi all
When I run text to columns once, it continues to apply those settings if I paste something else in afterwards. For example, I run text to columns on some comma separated data in my spreadsheet, but then if I try and paste in a sentence including commas it splits the sentence into separate columns too.
Is there anyway to stop this repetition behaviour? I can't find anything on the TTC dialog or in the Excel options.
Thanks in advance
dd/mm/yy
When I run text to columns once, it continues to apply those settings if I paste something else in afterwards. For example, I run text to columns on some comma separated data in my spreadsheet, but then if I try and paste in a sentence including commas it splits the sentence into separate columns too.
Is there anyway to stop this repetition behaviour? I can't find anything on the TTC dialog or in the Excel options.
Thanks in advance
dd/mm/yy