Excel

[tercertiempo]

Hi all:

I have a similar problem, I tried to modify the code
according to my situation but nothing worked.

I have three Worksheets in Excel, first one (sheet 1) with "X" values
from D11 to CJ105, second one (sheet 2) with "Y" values from D11 to
CJ105 too. In the third one, I need to Concatenate the values from
sheet 1 and 2 from D11 to CJ105.
I did =CONCATENATE(Sheet1!D11;" - ";Sheet2!D11);"%") and then copy
the Formula from D11 to CJ105 in sheet 3; the problem is that i have
to maintain the color of the font from sheet 2:

(=CONCATENATE(Sheet1!D11[black];" - "[black];Sheet2!
D11[red];"%"[red])

As I said, i really tried to modify what you have written but didn't
work.

Any solution would be really awesome!


Thanks a lot and sorry for my English!

 

[Pete_UK]

I don't know which "similar problem" you are referring to, but a
formula cannot return a format or colour, only a value. You can also
shorten your formula by using the & operator:

=Sheet1!D11&" - "&Sheet2!D11&"%"

One thing you can do after the formula has been copied to the cells in
sheet 3 is to highlight the same range in Sheet2, click <copy>, then
select Sheet3 and Edit | Paste Special | Formats (check) | OK, then
<Esc>. This will copy the formats (only) to Sheet3.

Hope this helps.

Pete

 

[Ferre]

Hi, thanks for all, the solution i'm referring is in
http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/560f22449b6a72fd