merge text in various files into one cell in a consolidated file

[mebennani]

good day, for those of you know who know a bit of accounting , i have a balance sheet template that is filled by 15 different units (one account per raw and comments for deviations), and I want to consolidate comments from all the 15 units in a consolidated balance sheet. ideally i would have the 15 comments (or less if not all have filled in comments) in one raw (per account), or the consolidated tab can be extanded so each account has 15 raws and then link them to the files?

Option (2) is i think easier to do but i might have only 5 comments in an account so i wont need all the 15 raws.

Let me know if unclear, thanks

 

[Esuomm1]

OK, unclear, ha ha.

Know some acctng, but not sure how you are using the term "RAW", sorry (and that's why it's unclear to me).

But why isn't combining text as easy as something like this: ='[A1 delete.xlsx]Sheet1'!$A$1&" - "&'[A2 delete.xlsx]Sheet1'!$A$1. File names are A1 delete.xlsx and A2 delete.xlsx and in cell A1 in each file says A1 from one file / A2 from one file
[TABLE="width: 48"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>[TR]
[TD="width: 64, bgcolor: transparent, align: left"]A1 from one file - A2 from one file[/TD]
[/TR]
</TBODY>[/TABLE]

 

[mebennani]

Thanks, I think you got what I mean, i have two small problems. When I bring A1 to the formula I want it to be bold while text in A2 should be normal. I want A2 to be in a new line within the same Cell (like Alt Enter)

Would that be possible in the same formula?

 

[Esuomm1]

I'm sorry, I don't think you can format part of the formula in a cell to look one way and the other part, another.

i.e. formula=A1&" - "&A2 returns Cat - Dog and the Cat can't be a different format from the Dog

Obv, you could copy, paste value and then format the results but I don't know that's what you're looking for.

 

[mebennani]

thanks, and is it possible to have Dog in a new line so it is like
Cat
Dog
within the same cell?