Ask Your Question

Text to Columns Problem

asked 2017-07-27 15:07:55 +0200

tonyvella gravatar image

I have a column of stamp catalogue numbers which sometimes includes "subs" such as 111a, 222b, etc. So I select the column and apply the Text to Columns function. The sort is perfect and I save the file! However, if I add more catalogue numbers to the column I have to use the Text to Columns option again because the column has reverted to standard. Is this normal or am I doing something wrong? Thanks in advance.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-07-29 09:19:14 +0200

Paul451 gravatar image

That's normal behaviour. T2C only works on the current data, it isn't going to change any new data you enter.

Question: Why are you continuing to enter the new catalogue numbers in the old format?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-27 15:07:55 +0200

Seen: 78 times

Last updated: Jul 29 '17