Re: Rearranging data in a text cell

That's it - thanks man!!!
David


"Norman Jones" wrote:

> Hi David,
>
> (1)> always want more, how do I limit it to only 3 cells
>
> The third Text to Columns wizard screen inludes a 'Do not import column
> (skip)' option which can be checked for columns 4+.
>
>
> (2)> Can you give me a quick overview on creating a macro? Have never
> > done one before.
>
> you may wish to visit David McRitchie's 'Getting Started With Macros And
> User Defined Functions' at:
>
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
>
> ---
> Regards,
> Norman
>
>
>
> "giddne" <giddne@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:5F7BD087-2621-45C8-BBC8-C10E72911A11@xxxxxxxxxxxxxxxx
> > Norman, great answer, works like a charm. Two questions though, ya know
> > we
> > always want more, how do I limit it to only 3 cells - (Doe John T)? I'm
> > not
> > interested in the rest of the data. I could delete them but would rather
> > not.
> >
> > Number 2 - Can you give me a quick overview on creating a macro? Have
> > never
> > done one before.
> >
> > Thanks again.
> > David
> >
> > "Norman Jones" wrote:
> >
> >> Hi David,
> >>
> >> With your data selected, try:
> >>
> >> Data | Text to columns | Delimited | Next | Select the 'Space' option
> >> | Next | Finish
> >>
> >> If you need to do this programmatically, turn on the macro recorder and
> >> perform the above manual operation.
> >>
> >> This should provide code which can be adapted for general application.
> >>
> >>
> >> ---
> >> Regards,
> >> Norman
> >>
> >>
> >>
> >> "giddne" <giddne@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:A29FDAD7-380B-4305-BB18-D97443EF77CB@xxxxxxxxxxxxxxxx
> >> >I have cells with names to use in direct mail. The current format could
> >> >be
> >> > many variations but I only need the first 3 names initials etc. such as
> >> > John
> >> > Doe or John W Doe. I am not interested in anything after that.
> >> > Putting
> >> > it
> >> > in 3 separate cells would be ideal but 1 or 2 would also be acceptable.
> >> >
> >> > Current formats include all of these:
> >> > Doe John
> >> > Doe John W
> >> > Doe John W JR
> >> > Doe John W & Doe Jane R
> >> >
> >> > Appreciate your help. Love this site!!
> >> > David
> >> >
> >> >
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: I cant format 01/19/2004 to read January 19, 2004, please hel
    ... > By the way, if you happen to know, how can I get rid of these damn spaces ... > efficiently I'd be eternally grateful! ... Additionally, if you are not familiar with macros, see David McRitchie's ... > Hello Norman, ...
    (microsoft.public.excel.misc)
  • Re: Auto fit in merged cells
    ... See David McRitchie's 'Getting Started With Macros And User Defined ... Regards, ... Norman ...
    (microsoft.public.excel.programming)
  • Re: Distinguishing blank cells
    ... Despite your clear signature, I called you David. ... > Hi Norman, Thank you. ... >> returns true if A1 an empty cell and false in the other cases you ... >>> Is there a way to distinguish the embedded blanks from the empty ...
    (microsoft.public.excel.misc)
  • Re: We may set something up! I saw you by accident and Im interested in you!!!!
    ... > I think all Tories are called David, ... > equivalent of Norman or Kenneth ...
    (rec.music.opera)
  • Re: Insert cell anywhere
    ... Thanks for replying again, I pasted your suggestion into my macro, it worked ... Regards J. ... "Norman Jones" wrote: ... > Sub Tester04() ...
    (microsoft.public.excel.programming)