Cell combine

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
First I'm sorry 'cause my English is not so good, I'll try do not make mistak
What I want to know is how can I combine cell ex.
a1 - a2 - a3 - a4 become in only one cel
I hope be clear, thanks any wa
Michael
 
Hi Michael!

No problems with your English!

=A1&A2&A3&A4

But often what you want is:

=A1&" "&A2&" "&A3&" "&A4

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
In A5:

=a1&a2&a3&a4
or
=a1 & " " & a2 & " " & a3 & " " & a4

(spaces for readability only.)
 
Dear Norman
I try it already but it is not what I want, let me explain by other wa
I saw once many empty cells working as one for example
A2 TO A6 WORK LIKE ONLY ONE
WHAT DOES MEAN
IF YOU ARE ON A
THEN PUSH THE RIGHT ARROW TO MOVE THE COURSOR TO THE NEXT CELL ONCE YOU'LL BE IN A2,A3,A4,A5 AND A6 AS THEM WILL BE ONLY ONE
THEN YOU PUSH THE RIGHT ARROW ONCE MORE, YOU GONNA BE IN A7 CEL
I know that's possible but Idon't know ho
thank yo
Michae
 
I think you're talking about merged cells (they are generally a bad idea).
You can merge cells by selecting (highlighting) them together and then using
Format | Cells | Alignment | Text Control | Merge Cells.

--

Vasant


Michael said:
Dear Norman:
I try it already but it is not what I want, let me explain by other way
I saw once many empty cells working as one for example
A2 TO A6 WORK LIKE ONLY ONE
WHAT DOES MEAN?
IF YOU ARE ON A1
THEN PUSH THE RIGHT ARROW TO MOVE THE COURSOR TO THE NEXT CELL ONCE YOU'LL
Click to expand...
BE IN A2,A3,A4,A5 AND A6 AS THEM WILL BE ONLY ONE,
 
Back
Top