Re: how do i do this ?
- From: Paul Sheppard <Paul.Sheppard.1una6l_1125518772.1134@xxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 31 Aug 2005 14:46:23 -0500
phil Wrote:
> sorry, i mustn't have explained properly.
> column a and b have different text in. i would like to make the text
> all
> together i one column?
>
>
> Hi Phil
>
> To merge TEXT from A & B
>
> assuming text starts in row 1, you can use this formula to merge the
> text:-
>
> =A1&" "&B1, drag this down the column you put the formula in to merge
> the remaining rows
> __________________
> Hope this helps
>
> Paul
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24783
View this thread: http://www.excelforum.com/showthread.php?threadid=400810
.
- References:
- RE: how do i do this ?
- From: Christine Lombardo
- Re: how do i do this ?
- From: phil
- RE: how do i do this ?
- Prev by Date: Re: Time *** turmoil.
- Next by Date: Formula to delete blank cells across multiple columns?
- Previous by thread: Re: how do i do this ?
- Next by thread: IF function
- Index(es):