Prev: Percentage Help
Next: ratio using DATEDIF function
From: Endalk Tessema on 8 Mar 2010 03:56
Hi was trying to merge two colums in to one, and both columns have about 500
client lists. In column A I have first name and in Column B I had Clients
last name. But I wanted to do both in on columns. So instead of doing one at
a time I created the following formula in C 1 >>>
=CONCATENATE(Sheet1!$A:$A&" "&Sheet1!$B:$B)
.... then I select my Formula in C1, then select all the way to client nuber
500 (C500), that means I have highlighted the column C1 to C500, then click
>> Fill, then click >> down. That makes the same exact formula from C1 to
C500. then enter. That will merge all the values in column A and column B.
Note: pls note in the formula there two same words > Sheet1. That is the
sheet you are working on. Normally when we open excel we have Sheet1, Sheet2
and Sheet3 at the bottom of the worksheet we are currently working. So If you
already renamed it pls use your name instead of Sheet1, or Sheet2 if you are
working on sheet 2.
--
www.wilshiretrans.com
Limos, Taxis, Shuttles, Stretches, and Buses.


"David Biddulph" wrote:

> In your situation, don't try to do a text concatenation.
> Just use =B2+C2 and format the cell appropriately, such as:
> mm/dd/yyyy hh:mm:ss
> --
> David Biddulph
>
> "Steve B" <SteveB(a)discussions.microsoft.com> wrote in message
> news:25C604EB-D83E-4633-87DE-80C0638A6E29(a)microsoft.com...
> >I was having this same problem...However the two columns I am trying to
> >merge
> > have a date and the time. So when I merge the two columns I am getting
> > the
> > number form of the date in return. I have tried changing the format to
> > show
> > the date and the time but its still returning the number? What should I
> > do
> > to fix this problem?
> >
> > B2=7/23/07
> > C2=0:00:16
> >
> > What I want in D2 is: 7/23/07 0:00:16
> > What I am getting is: 39286 0.00185185....
>
> > "Titanium" wrote:
> >
> >> I am trying to 'make one' a number of columns...
> >> Essentially I have several thousand rows of data that I need to clean
> >> up...
> >> What I would like to accomplish is Column A + B = AB
> >>
> >> Column A Data: I need this one first
> >> Column B Data: and this one comes right behind with a space for proper
> >> grammer
> >> To equal one column: I need this one first and this one comes right
> >> behind
> >> with a space for proper grammer.
> >>
> >> Thanks in advance for any input!
> >>
> >> Ti
>
>
>
 | 
Pages: 1
Prev: Percentage Help
Next: ratio using DATEDIF function