Guide:help

I have a column in an excel sheet (max 65000 rows) which contains text. I
want to strip off the first word of the text string and place this into a
different column leaving the rest(minus this one word) in the original
column cell. in toal i have 85000 records and doing this by hand will take
for ever. Once this is done I will transfer all records to an access
database.

can some one please give me a guide on how to go about doing this

In an adjacent column

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

and copy down.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TONY" <STEELE_ANTHONY at HOTMAIL.COM> wrote in message
news:[email protected]...
> I have a column in an excel sheet (max 65000 rows) which contains text. I
> want to strip off the first word of the text string and place this into a
> different column leaving the rest(minus this one word) in the original
> column cell. in toal i have 85000 records and doing this by hand will take
> for ever. Once this is done I will transfer all records to an access
> database.
>
> can some one please give me a guide on how to go about doing this
>
>

dear Bob thank you for the help.
this answers part of my problem perfectly ..it strips off the first word.

i would like to put the first word in column 'C' in column "a" and the
remainder of the text (minus the first word into column 'B' your
suggestion does the second part perfectly. can you suggest how i now get
just the first word of the text into column 'A'

many thanks

Tony

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> In an adjacent column
>
> =RIGHT(A1,LEN(A1)-FIND(" ",A1))
>
> and copy down.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "TONY" <STEELE_ANTHONY at HOTMAIL.COM> wrote in message
> news:[email protected]...
>> I have a column in an excel sheet (max 65000 rows) which contains text. I
>> want to strip off the first word of the text string and place this into a
>> different column leaving the rest(minus this one word) in the original
>> column cell. in toal i have 85000 records and doing this by hand will
>> take
>> for ever. Once this is done I will transfer all records to an access
>> database.
>>
>> can some one please give me a guide on how to go about doing this
>>
>>
>
>

How about

=TRIM(SUBSTITUTE(A1,RIGHT(A1,LEN(A1)-FIND(" ",A1)),""))


--

Regards,

Peo Sjoblom

"TONY" <STEELE_ANTHONY at HOTMAIL.COM> wrote in message
news:[email protected]...
> dear Bob thank you for the help.
> this answers part of my problem perfectly ..it strips off the first word.
>
> i would like to put the first word in column 'C' in column "a" and the
> remainder of the text (minus the first word into column 'B' your
> suggestion does the second part perfectly. can you suggest how i now get
> just the first word of the text into column 'A'
>
> many thanks
>
> Tony
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > In an adjacent column
> >
> > =RIGHT(A1,LEN(A1)-FIND(" ",A1))
> >
> > and copy down.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "TONY" <STEELE_ANTHONY at HOTMAIL.COM> wrote in message
> > news:[email protected]...
> >> I have a column in an excel sheet (max 65000 rows) which contains text.
I
> >> want to strip off the first word of the text string and place this into
a
> >> different column leaving the rest(minus this one word) in the original
> >> column cell. in toal i have 85000 records and doing this by hand will
> >> take
> >> for ever. Once this is done I will transfer all records to an access
> >> database.
> >>
> >> can some one please give me a guide on how to go about doing this
> >>
> >>
> >
> >
>
>

Peo,
a million thanks... my problem now solved..

best wishes

Tony
"Peo Sjoblom" <[email protected]> wrote in message
news:[email protected]...
> How about
>
> =TRIM(SUBSTITUTE(A1,RIGHT(A1,LEN(A1)-FIND(" ",A1)),""))
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "TONY" <STEELE_ANTHONY at HOTMAIL.COM> wrote in message
> news:[email protected]...
>> dear Bob thank you for the help.
>> this answers part of my problem perfectly ..it strips off the first word.
>>
>> i would like to put the first word in column 'C' in column "a" and the
>> remainder of the text (minus the first word into column 'B' your
>> suggestion does the second part perfectly. can you suggest how i now get
>> just the first word of the text into column 'A'
>>
>> many thanks
>>
>> Tony
>>
>> "Bob Phillips" <[email protected]> wrote in message
>> news:[email protected]...
>> > In an adjacent column
>> >
>> > =RIGHT(A1,LEN(A1)-FIND(" ",A1))
>> >
>> > and copy down.
>> >
>> > --
>> >
>> > HTH
>> >
>> > RP
>> > (remove nothere from the email address if mailing direct)
>> >
>> >
>> > "TONY" <STEELE_ANTHONY at HOTMAIL.COM> wrote in message
>> > news:[email protected]...
>> >> I have a column in an excel sheet (max 65000 rows) which contains
>> >> text.
> I
>> >> want to strip off the first word of the text string and place this
>> >> into
> a
>> >> different column leaving the rest(minus this one word) in the original
>> >> column cell. in toal i have 85000 records and doing this by hand will
>> >> take
>> >> for ever. Once this is done I will transfer all records to an access
>> >> database.
>> >>
>> >> can some one please give me a guide on how to go about doing this
>> >>
>> >>
>> >
>> >
>>
>>
>
>