James has attended:
Excel Intermediate course
Excel Advanced course
Excelt Pasting
Whenever I past a spreadsheet from outlook's excel & our Delphi system what usually would happen would be that the columns would automatically be distributed correctly. Now after fiddling with 'text to columns' option this is all pasting into one column. Is there any suitable fix to put my settings back to how they were originally?
RE: Excelt Pasting
Hello James,
The following fix might help solve your problem:
Try typing any text character in a cell, then activate DATA|Text_to_Columns. Now choose the Delimited option and clear all of the Delimiters setting boxes.
Hopefully, this will clear any Text to Columns settings causing the problem.
If it doesn't work, please let us know so that we can try a different solution.
Kind regards
Marius Barnard
STL
