Ask Your Question

Text to Columns Problem [closed]

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

tonyvella gravatar image

updated 2020-08-30 12:23:35 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-30 12:24:01.186995

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

Question Tools

1 follower


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

Seen: 164 times

Last updated: Jul 29 '17