Re: how do i do this ?
- From: "phil" <phil@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 31 Aug 2005 18:26:03 +0100
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?
"Christine Lombardo" <ChristineLombardo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:B6ECE90F-0CEB-40FB-B923-6A411E44B8D5@xxxxxxxxxxxxxxxx
> If I understood your question correctly, I believe what you need to do is
> in
> column c you need to put =sum(column A + column B)
> This will give you the sum in column C
>
> "phil" wrote:
>
>> if i have 2 columns with different information in them how do i merge the
>> two to become one column with all the information in?
>> i'm trying to use vlookup to search a list of equipment (column B) and
>> give
>> me the figure in the box next to it (column C) but some of the info i
>> need
>> to find it is in the first column (column A) so i would like to merge the
>> 2
>> together . (A+B)
>>
>> hope this makes sense ?
>>
>> thanks for your help
>>
>> Phil
>>
>>
>>
.
- Follow-Ups:
- Re: how do i do this ?
- From: Paul Sheppard
- Re: how do i do this ?
- References:
- RE: how do i do this ?
- From: Christine Lombardo
- RE: how do i do this ?
- Prev by Date: Re: Time *** turmoil.
- Next by Date: Embedding a Sumif in a sumif
- Previous by thread: RE: how do i do this ?
- Next by thread: Re: how do i do this ?
- Index(es):