Very joyful. Sent from the all new AOL app for Android On Fri, Jul 8, 2022 at 0:01, David Deeks<[email protected]> wrote: Great explanation Brian - a feature I’d never really understood before so just ignored, certainly an ingenious use of it on this occasion, may well come back to it in future for its intended purpose!
Thanks again for your help. Doubt your expertise? Never! All best David > On 7 Jul 2022, at 03:57, Brian Barker <[email protected]> > wrote: > > At 23:15 05/07/2022 +0100, David Deeks wrote: >> Sorry Brian, I was just being courteous - I thought if I included everyone >> with my follow-up query it would look like I was doubting your expertise! > > Oh, it's perfectly OK to doubt my expertise. > >> ... everything now seems to be hunky dory. > > Good-oh! > >> So "text to columns" converts to text those cells originally entered as >> numbers? > > No, rather the other way around: your text values are converted to numbers. > > The normal use of Text to Columns... is to divide text in one column into > multiple columns. So if you have names such as "David Deeks" in one column > and you use Text to Columns... with Space ticked, you will get "David" in the > original column and "Deeks" in the next column to the right (with the > intervening space helpfully swallowed up). But in the process, it appears > that values are reinterpreted, just as they would be if the data was entered > afresh. So a text value "1000" is treated as if you had typed 1000, in other > words as the number one thousand, not the four text characters. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
