Combining 4 cells into one

ewtodd · Apr 23rd, 2002, 07:52 AM

Lets say I have in a1 to d1 this + + + + in four different cells and in e1 I need to combine them to show "++++" in one cell. Thanks for any advice

Audiojoe · Apr 23rd, 2002, 07:53 AM

Sure, you need to use the concatenate function. In E1 put this formula:

=CONCATENATE(A1,B1,C1,D1)

Audiojoe

Jack in the UK · Apr 23rd, 2002, 03:27 PM

or

you must type this all in one cell ie select the cell and press F2 then paste else it will fill a few cells down and not work, or double click to entre the cell top paste

=A1&
" "&
B1&
" "&
C1&
" "&
D1

now this i make formula this ways as i teach guys so they can edit them and understand the construction. also this way you and tweak and edit with ease ive added a space between cells jsut to devide them can be removed,

THIS is MY way or formula, not very pretty just like me i guess..

HTH

Apr 23rd, 2002, 03:27 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	or you must type this all in one cell ie select the cell and press F2 then paste else it will fill a few cells down and not work, or double click to entre the cell top paste =A1& " "& B1& " "& C1& " "& D1 now this i make formula this ways as i teach guys so they can edit them and understand the construction. also this way you and tweak and edit with ease ive added a space between cells jsut to devide them can be removed, THIS is MY way or formula, not very pretty just like me i guess.. HTH __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 07:52 AM	#1
ewtodd New Member Join Date: Apr 2002 Location: Eric Posts: 3	Lets say I have in a1 to d1 this + + + + in four different cells and in e1 I need to combine them to show "++++" in one cell. Thanks for any advice

Apr 23rd, 2002, 07:53 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Sure, you need to use the concatenate function. In E1 put this formula: =CONCATENATE(A1,B1,C1,D1) Audiojoe