Greetings. I need a little help. Is it possible to combine text from to
different cells together with a formula? Example: A1 = My name B1 = is
Will, and I want C1 to say My name is Will. Is this possible? Thanks in
advance for any help.
Greetings. I need a little help. Is it possible to combine text from to
different cells together with a formula? Example: A1 = My name B1 = is
Will, and I want C1 to say My name is Will. Is this possible? Thanks in
advance for any help.
Yep....
=CONCATENATE(A1,B1)
--
Regards,
Dave
"coal_miner" wrote:
> Greetings. I need a little help. Is it possible to combine text from to
> different cells together with a formula? Example: A1 = My name B1 = is
> Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> advance for any help.
Yep....
=CONCATENATE(A1,B1)
--
Regards,
Dave
"coal_miner" wrote:
> Greetings. I need a little help. Is it possible to combine text from to
> different cells together with a formula? Example: A1 = My name B1 = is
> Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> advance for any help.
Thank you, works perfect.
"DaveB" wrote:
> Yep....
>
> =CONCATENATE(A1,B1)
>
> --
> Regards,
>
> Dave
>
>
> "coal_miner" wrote:
>
> > Greetings. I need a little help. Is it possible to combine text from to
> > different cells together with a formula? Example: A1 = My name B1 = is
> > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > advance for any help.
Thank you, works perfect.
"DaveB" wrote:
> Yep....
>
> =CONCATENATE(A1,B1)
>
> --
> Regards,
>
> Dave
>
>
> "coal_miner" wrote:
>
> > Greetings. I need a little help. Is it possible to combine text from to
> > different cells together with a formula? Example: A1 = My name B1 = is
> > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > advance for any help.
Thank you, works perfect.
"DaveB" wrote:
> Yep....
>
> =CONCATENATE(A1,B1)
>
> --
> Regards,
>
> Dave
>
>
> "coal_miner" wrote:
>
> > Greetings. I need a little help. Is it possible to combine text from to
> > different cells together with a formula? Example: A1 = My name B1 = is
> > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > advance for any help.
Thank you, works perfect.
"DaveB" wrote:
> Yep....
>
> =CONCATENATE(A1,B1)
>
> --
> Regards,
>
> Dave
>
>
> "coal_miner" wrote:
>
> > Greetings. I need a little help. Is it possible to combine text from to
> > different cells together with a formula? Example: A1 = My name B1 = is
> > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > advance for any help.
Yep....
=CONCATENATE(A1,B1)
--
Regards,
Dave
"coal_miner" wrote:
> Greetings. I need a little help. Is it possible to combine text from to
> different cells together with a formula? Example: A1 = My name B1 = is
> Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> advance for any help.
Yep....
=CONCATENATE(A1,B1)
--
Regards,
Dave
"coal_miner" wrote:
> Greetings. I need a little help. Is it possible to combine text from to
> different cells together with a formula? Example: A1 = My name B1 = is
> Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> advance for any help.
Yep....
=CONCATENATE(A1,B1)
--
Regards,
Dave
"coal_miner" wrote:
> Greetings. I need a little help. Is it possible to combine text from to
> different cells together with a formula? Example: A1 = My name B1 = is
> Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> advance for any help.
Thank you, works perfect.
"DaveB" wrote:
> Yep....
>
> =CONCATENATE(A1,B1)
>
> --
> Regards,
>
> Dave
>
>
> "coal_miner" wrote:
>
> > Greetings. I need a little help. Is it possible to combine text from to
> > different cells together with a formula? Example: A1 = My name B1 = is
> > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > advance for any help.
Another way to do the same thing is
=A1&B1
But in either case, you need either a trailing space in A1 or a leading
space in B1 to keep it from reading "My nameis Will"
or, you can do it in the formula, as:
=A1&" "&B1
Vaya con Dios,
Chuck, CABGx3
"coal_miner" wrote:
> Thank you, works perfect.
>
> "DaveB" wrote:
>
> > Yep....
> >
> > =CONCATENATE(A1,B1)
> >
> > --
> > Regards,
> >
> > Dave
> >
> >
> > "coal_miner" wrote:
> >
> > > Greetings. I need a little help. Is it possible to combine text from to
> > > different cells together with a formula? Example: A1 = My name B1 = is
> > > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > > advance for any help.
Another way to do the same thing is
=A1&B1
But in either case, you need either a trailing space in A1 or a leading
space in B1 to keep it from reading "My nameis Will"
or, you can do it in the formula, as:
=A1&" "&B1
Vaya con Dios,
Chuck, CABGx3
"coal_miner" wrote:
> Thank you, works perfect.
>
> "DaveB" wrote:
>
> > Yep....
> >
> > =CONCATENATE(A1,B1)
> >
> > --
> > Regards,
> >
> > Dave
> >
> >
> > "coal_miner" wrote:
> >
> > > Greetings. I need a little help. Is it possible to combine text from to
> > > different cells together with a formula? Example: A1 = My name B1 = is
> > > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > > advance for any help.
Another way to do the same thing is
=A1&B1
But in either case, you need either a trailing space in A1 or a leading
space in B1 to keep it from reading "My nameis Will"
or, you can do it in the formula, as:
=A1&" "&B1
Vaya con Dios,
Chuck, CABGx3
"coal_miner" wrote:
> Thank you, works perfect.
>
> "DaveB" wrote:
>
> > Yep....
> >
> > =CONCATENATE(A1,B1)
> >
> > --
> > Regards,
> >
> > Dave
> >
> >
> > "coal_miner" wrote:
> >
> > > Greetings. I need a little help. Is it possible to combine text from to
> > > different cells together with a formula? Example: A1 = My name B1 = is
> > > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > > advance for any help.
Another way to do the same thing is
=A1&B1
But in either case, you need either a trailing space in A1 or a leading
space in B1 to keep it from reading "My nameis Will"
or, you can do it in the formula, as:
=A1&" "&B1
Vaya con Dios,
Chuck, CABGx3
"coal_miner" wrote:
> Thank you, works perfect.
>
> "DaveB" wrote:
>
> > Yep....
> >
> > =CONCATENATE(A1,B1)
> >
> > --
> > Regards,
> >
> > Dave
> >
> >
> > "coal_miner" wrote:
> >
> > > Greetings. I need a little help. Is it possible to combine text from to
> > > different cells together with a formula? Example: A1 = My name B1 = is
> > > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > > advance for any help.
Another way to do the same thing is
=A1&B1
But in either case, you need either a trailing space in A1 or a leading
space in B1 to keep it from reading "My nameis Will"
or, you can do it in the formula, as:
=A1&" "&B1
Vaya con Dios,
Chuck, CABGx3
"coal_miner" wrote:
> Thank you, works perfect.
>
> "DaveB" wrote:
>
> > Yep....
> >
> > =CONCATENATE(A1,B1)
> >
> > --
> > Regards,
> >
> > Dave
> >
> >
> > "coal_miner" wrote:
> >
> > > Greetings. I need a little help. Is it possible to combine text from to
> > > different cells together with a formula? Example: A1 = My name B1 = is
> > > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > > advance for any help.
Another way to do the same thing is
=A1&B1
But in either case, you need either a trailing space in A1 or a leading
space in B1 to keep it from reading "My nameis Will"
or, you can do it in the formula, as:
=A1&" "&B1
Vaya con Dios,
Chuck, CABGx3
"coal_miner" wrote:
> Thank you, works perfect.
>
> "DaveB" wrote:
>
> > Yep....
> >
> > =CONCATENATE(A1,B1)
> >
> > --
> > Regards,
> >
> > Dave
> >
> >
> > "coal_miner" wrote:
> >
> > > Greetings. I need a little help. Is it possible to combine text from to
> > > different cells together with a formula? Example: A1 = My name B1 = is
> > > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > > advance for any help.
Thank you, works perfect.
"DaveB" wrote:
> Yep....
>
> =CONCATENATE(A1,B1)
>
> --
> Regards,
>
> Dave
>
>
> "coal_miner" wrote:
>
> > Greetings. I need a little help. Is it possible to combine text from to
> > different cells together with a formula? Example: A1 = My name B1 = is
> > Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> > advance for any help.
> Greetings. I need a little help. Is it possible to combine text
from to
> different cells together with a formula?
=A1&B1
=A1&" "&B1
=A1&" "&B1&" Smith"
etc. etc. etc.
arno
> Greetings. I need a little help. Is it possible to combine text
from to
> different cells together with a formula?
=A1&B1
=A1&" "&B1
=A1&" "&B1&" Smith"
etc. etc. etc.
arno
> Greetings. I need a little help. Is it possible to combine text
from to
> different cells together with a formula?
=A1&B1
=A1&" "&B1
=A1&" "&B1&" Smith"
etc. etc. etc.
arno
> Greetings. I need a little help. Is it possible to combine text
from to
> different cells together with a formula?
=A1&B1
=A1&" "&B1
=A1&" "&B1&" Smith"
etc. etc. etc.
arno
> Greetings. I need a little help. Is it possible to combine text
from to
> different cells together with a formula?
=A1&B1
=A1&" "&B1
=A1&" "&B1&" Smith"
etc. etc. etc.
arno
Yep....
=CONCATENATE(A1,B1)
--
Regards,
Dave
"coal_miner" wrote:
> Greetings. I need a little help. Is it possible to combine text from to
> different cells together with a formula? Example: A1 = My name B1 = is
> Will, and I want C1 to say My name is Will. Is this possible? Thanks in
> advance for any help.
> Greetings. I need a little help. Is it possible to combine text
from to
> different cells together with a formula?
=A1&B1
=A1&" "&B1
=A1&" "&B1&" Smith"
etc. etc. etc.
arno
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks