excel question

Reply Subscribe

Thread Tools

Jun 20, 2005 | 12:16 PM

#11

flipped cracka

BOOM goes the dynamite!

Joined: Mar 2003

Posts: 27,571

Likes: 1

From: in a van down by the rive

you can use CONCATENATE if you want to put them together into a different cell.

Jun 20, 2005 | 12:18 PM

#12

Grifter

Thread Starter

Senior Member

Joined: Dec 2000

Posts: 44,835

Likes: 0

From: the southwest

Quote:

Originally Posted by joebenz

select the ones you want to merge and then click the "merge and center" button. it looks like a little box with an a in the middle

that only does one at a time and it deletes the data from the second cell

Jun 20, 2005 | 12:19 PM

#13

Grifter

Thread Starter

Senior Member

Joined: Dec 2000

Posts: 44,835

Likes: 0

From: the southwest

Quote:

Originally Posted by flipped cracka

you can use CONCATENATE if you want to put them together into a different cell.

so can i columnA CONCATENATE columnB?

Jun 20, 2005 | 12:49 PM

#14

flipped cracka

BOOM goes the dynamite!

Joined: Mar 2003

Posts: 27,571

Likes: 1

From: in a van down by the rive

Quote:

Originally Posted by Grifter

so can i columnA CONCATENATE columnB?

http://domino.lancs.ac.uk/pub/usghel...A?OpenDocument

Jun 20, 2005 | 08:03 PM

#15

jclau00

Senior Member

Joined: Sep 2002

Posts: 1,104

Likes: 0

From: bay area, cali

to find duplicate entries, you can use a countif formula.

to combine two cells you can use concatenate as mentioned above, or you can use ampersands and quotation marks.

Jun 20, 2005 | 08:10 PM

#16

95SiR

hood rich

Joined: Mar 2012

Posts: 35,752

Likes: 0

From: los josengeles

Quote:

Originally Posted by joebenz

import it into access and create a query. i know access can do what you want. but i dont know access enough to tell you how to do it

that made me :chuckles:

__________________
In Loving Memory
R.I.P. Huan Vo aka woong
01.14.1979 - 11.19.2008

Reply Subscribe

Reply Share

First
Prev
2 / 2
Next
Last

Forum Jump