If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
conecting 2 cells with diferent format in 1 cell
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 |
#2
|
|||
|
|||
conecting 2 cells with diferent format in 1 cell
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, 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 . |
#3
|
|||
|
|||
conecting 2 cells with diferent format in 1 cell
thanks i did it, but was necessary a trick, copy to another cell, cos like u sayd my result was:
A1 A2 A3 A4 nuno .... 1245 nunoâ–¡1245 as i tryed A1 A2 A3 A4 A5(copyA4) nuno .... 1245 nunoâ–¡1245 nuno 1245 is it for being diferent excell or diferent languages??? well anyway thanks a lot "Jason Morin" escreveu: 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, 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 . |
Thread Tools | |
Display Modes | |
|
|