Excel Question

[bigblockmatt]

I got me an excel question for you all. I got a sheet that i want to copy text from cell to cell. so what i did is, for example, i entered text in cell 1A. in cell 1C, i have +1A so that it shows what i have in 1A. My problem is that my formatting done in 1A does not transfer through to 1C, i have half the text in 1A italicized. anyone have any ideas?

[FZ1]

in cell 1C, i have +1A

Do you mean "=A1"? I don't think you can intrinsically convey formatting through a formula. Maybe I'm misunderstanding the question.

[bigblockmatt]

ya, "=1A", "+1A" works the same though. it is easier to enter the + rather than the = when doing lots of numbers.

[bubba]

do you want what ever you have as a result for 1A added to in cell 1C

then in the cell for 1C you would have =X+1A where 'X' is the kown you want to add to it or another formula.

if you just have the =1A it will just copy what ever it is you input to 1A in 1C

so lets say you have a ro if cells you want to add up. 6A through 6C

in cell 1a you would have =SUM(A6:C6) then you whant to divide that by a known number lets say 10 then in cell 1C you would have =A1/10

**edit**
if your tacking text onto the end of text that is in in cell 1A then in 1C you would have =CONCATENATE(A1," this is tacked on in 1c") or like this =A1&" this is tacked on" you can tack on cells of text, but there is a limit to how many can be tacked on to one another, it in the high 20's

[bigblockmatt]

i dont want to add anything. I want cell C1 to equal/look exact the same as A1.

that way, when i want to change A1, to will also be changed in C1 with out having to actually change C1.

Thanks for the help thus far!!

[DMB2000uk]

Is the formatting of the cell A1 changing at all?
If its not, you should just be able to format the C1 cell the same, and it should display the same.

Dan

[bigblockmatt]

I cant format cell C1 the same. I have (in A1) half of the text italicized and half not. when i have C1 "=A1" it does not bring of the italicized. it brings all the text, just not the text formatting.

[bubba]

well that sucks, I tried the the Format Painter but it made the whole cell italic...

think you're up a creek, unless you can find the code to do inline Italic text, dont think excel has that.

[bigblockmatt]

ya, it is stupid. thats what i have concluded.