conecting 2 cells with diferent format in 1 cell

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

Guest

i want to have a cell with data from 2 diferent cells, but with diferent format like discription below, and A4 is in diferent sheet:
A1 A2 A3 A4
nuno .... 1245 nuno (bold)
1245
A1 A2 A3 A4
filipe .... 1452 filipe (bold)
1452
.............
i can do the conection of A1&A3, but how do i put the number all time below of name, cos i'm not getting there. A4 will do to identifier!

Can anione help me, cos i have thousend of data like this to do.....
thanks
 
You can't format the contents of cell in multiple ways
when it contains a formula, but with regard to placing
the number below the words:

=A1&CHAR(10)&A3

and wrap the text.

HTH
Jason
Atlanta, GA
-----Original Message-----
i want to have a cell with data from 2 diferent cells,
Click to expand...
but with diferent format like discription below, and A4
is in diferent sheet:
A1 A2 A3 A4
nuno .... 1245 nuno (bold)
1245
A1 A2 A3 A4
filipe .... 1452 filipe (bold)
1452
.............
i can do the conection of A1&A3, but how do i put the
Click to expand...
number all time below of name, cos i'm not getting there.
A4 will do to identifier!
 
Back
Top