Use text->column

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #196,010 by bepatient 2/22/05 6:29:15 PM Reply	Use text->column Tell it that the source is delimited by a space. You will get x/x/xxx then 1:11:11 then AM. You need to have the 2 columns to the right open to accept the data from the split. Excel isn't smart enough to add the columns for this operation. If you push something hard enough, it will fall over. _{Fudd's First Law of Opposition} [link\|mailto:bepatient@aol.com\|BePatient]
Post #196,038 by pwhysall 2/23/05 1:40:12 AM Reply	People! This string stuff won't work! Dollars to donuts column A is a date/time value - i.e. a number. Excel is formatting it mm/dd/yyyy HH:MM:SS PM This is not a string you can do "left() right(), mid() etc" on. It's a NUMBER. Of course, if it really is a string, then ignore me. But I bet it isn't. Peter [link\|http://www.ubuntulinux.org\|Ubuntu Linux] [link\|http://www.kuro5hin.org\|There is no K5 Cabal] [link\|http://guildenstern.dyndns.org\|Home] Use P2P for legitimate purposes!
Post #196,045 by CRConrad 2/23/05 2:24:54 AM Reply	Yep, yer probably right. Peculiar, though. I would have... ...thought that Excel would forcibly convert it to a string all by itself, and then taken the right-most sub-string of that -- it certainly does enough "helpful" stuff like that when you don't want it to, so why on Earth not now? Weirdski. [link\|mailto:MyUserId@MyISP.CountryCode\|Christian R. Conrad] (I live in Finland, and my e-mail in-box is at the Saunalahti company.) Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link\|http://z.iwethey.org/forums/render/content/show?contentid=71575\|Ashton Brown]

Excel Question - (alvitale) - (20) - Feb. 22, 2005, 04:24:57 PM EST

If that's an actual time... - (pwhysall) - Feb. 22, 2005, 04:27:40 PM EST

Enter in TargetCell: "=Right(SourceCell, 12)" HTH! (HTW :-) -NT - (CRConrad) - (8) - Feb. 22, 2005, 04:28:56 PM EST

Will only work for string literals - (pwhysall) - (7) - Feb. 22, 2005, 04:29:29 PM EST

Al's question looks like string literals are what it's about -NT - (CRConrad) - (6) - Feb. 22, 2005, 04:31:13 PM EST

Looks like Excel's default rendition of a date/time serial -NT - (pwhysall) - (5) - Feb. 22, 2005, 04:31:42 PM EST

Default? On Yank Winders, perhaps, yes... - (CRConrad) - (4) - Feb. 23, 2005, 02:18:14 AM EST

Al's Winders will be Yankish, I wot. -NT - (pwhysall) - (3) - Feb. 23, 2005, 03:25:53 AM EST

Quite possib -- hey, quite *probable*, even! -NT - (CRConrad) - (2) - Feb. 23, 2005, 03:50:57 AM EST

And they'll all buffer overflow on 12/31/2024 -NT - (ChrisR) - (1) - Feb. 23, 2005, 09:44:53 AM EST

Why then; izzat when Al's Social Security runs out, or...? -NT - (CRConrad) - Feb. 23, 2005, 09:46:57 AM EST

Use text->column - (bepatient) - (2) - Feb. 22, 2005, 06:29:15 PM EST

People! - (pwhysall) - (1) - Feb. 23, 2005, 01:40:12 AM EST

Yep, yer probably right. Peculiar, though. I would have... - (CRConrad) - Feb. 23, 2005, 02:24:54 AM EST

If Peter is right, and that's a numeric date-time value... - (CRConrad) - (4) - Feb. 23, 2005, 02:50:54 AM EST

Correct - (bepatient) - (3) - Feb. 23, 2005, 07:10:49 AM EST

/me falls over - (pwhysall) - (1) - Feb. 23, 2005, 07:12:16 AM EST

Settle down fella - (bepatient) - Feb. 23, 2005, 02:37:50 PM EST

Well, yes- but maybe he wants the original one *also*. (Al?) - (CRConrad) - Feb. 23, 2005, 09:44:12 AM EST

If you want a text result... - (Steven A S) - (1) - Feb. 23, 2005, 03:33:19 PM EST

Thanks to all who contributed. I didn't respond to the - (alvitale) - Feb. 25, 2005, 04:27:25 PM EST

iwethey.org

A few lettuce pieces short of a salad.
44 ms