Ky04
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 6 articles for 0.302 sec
that was even easier! thanks to everyone! "Dave Peterson" wrote: > If the text is always 2 characters, you can still use Data|text to columns. But > choose fixed width--not delimited. > > > > rebc wrote: > > > > Hi, > > > > I have a column of text > > > > ny17 > > ca13 > > ky04 > > > > I want to be able to split the text and numbers into two separate columns, > > "ny"     

Group: microsoft.public.excel.misc · Group Profile · Search for Ky04 in microsoft.public.excel.misc
Author: rebc
Date: Aug 17, 2007 10:26

Well, that was embarrassingly easy. Thanks for making my day! :) RC "Gary''s Student" wrote: You show two letters and two numbers. for these: =LEFT(A1,2) and =RIGHT(A1,2) -- Gary''s Student - gsnu200738 "rebc" wrote: Hi, I have a column of text ny17 ca13 ky04 I want to be able to split the text and numbers
Show full article (0.83Kb) · Show article thread
If the text is always 2 characters, you can still use Data|text to columns. But choose fixed width--not delimited. rebc wrote: > > Hi, > > I have a column of text > > ny17 > ca13 > ky04 > > I want to be able to split the text and numbers into two separate columns, > "ny" in one, "17" in another. As you can see there's no delimiter. Since I > know excel can recognize the difference     

Group: microsoft.public.excel.misc · Group Profile · Search for Ky04 in microsoft.public.excel.misc
Author: rebc
Date: Aug 17, 2007 08:52

You show two letters and two numbers. for these: =LEFT(A1,2) and =RIGHT(A1,2) -- Gary''s Student - gsnu200738 "rebc" wrote: Hi, I have a column of text ny17 ca13 ky04 I want to be able to split the text and numbers into two separate columns, "ny" in one, "17" in another. As you can see there's no delimiter. Since I know excel can recognize the
Show full article (0.84Kb) · Show article thread
Hi, I have a column of text ny17 ca13 ky04 I want to be able to split the text and numbers into two separate columns, "ny" in one, "17" in another. As you can see there's no delimiter. Since I know excel can recognize the difference between text and a number I know there's a way to do it but I don't know what it is. Alternatively, I would be happy to find a way to insert a delimiter     

Group: microsoft.public.excel.misc · Group Profile · Search for Ky04 in microsoft.public.excel.misc
Author: Dave Peterson
Date: Aug 17, 2007 08:46

.... åÄÉÎÓÔ×ÅÅÎÙÊ, ÞØÉ ËÎÉÇÉ ÅÝÅ ×ÏÒÕÀÔ ÉÚ ÍÁÇÁÚÉÎÏ× É ÂÉÂÌÉÏÔÜË. äÕÒÁÛËÉ.... begin 666 best_of_xxx-1150180254_i_8157.jpg M_]C_X `02D9)1@`!`0```0`!``#__@`[0U)%%051/4CH@9V0M:G!E9R!V,2XP M("AU<VEN9R!)2D<@2E!%%1R!V-C(I+"!Q=6%%L:71Y(#T@.# *_]L`0P`&! 4& M!00&!@4&!P<&" H0"@H)"0H4#@\,$!<4&!@7%%!86&ATE'QH;(QP6%%B L(",F M)RDJ*1D?+3 M*# E*"DH_]L`0P$'!P<*" H3"@H3*!H6&B@H*"@H*"@H*"@H M*"@H*"@H*"
Show full article (0.70Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Ky04 in microsoft.public.excel.misc
Author: Gary''s Student
Date: Aug 17, 2007 08:36

Show full article (0.68Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Ky04 in microsoft.public.excel.misc
Author: rebc
Date: Aug 17, 2007 08:32

Show full article (0.50Kb)
    

Group: relcom.humor · Group Profile · Search for Ky04 in relcom.humor
Author: Igor Kopeikin
Date: Jun 14, 2006 23:27

Show full article (47.98Kb)