quick excel question , generating text paragraph from cells

eoinf

Is it possible to use excel to generate text based on the entrys in particular cells

ie

for (a3) by (a4) from (a5) ect ect

anyone got any suggestions what to do i presume its done through a macro of some discription

Cheers

Eoin

unkel

Use the concatenate function. I.e. cell A1 has eoinf in it. In cell B1 type in:

=concatenate("This is a solution for: ",A1)

eoinf

that looks like what i want ok . but it puts all the text in one cell.

would it then be possible to output this cell to a word file.

just remebered one thing some of these excel files will be read only so i wont be able to use the function on that particular file. any suggestions of getting around this rather than having to save a new version of the file and then run the function

unkel

eoinf wrote:

would it then be possible to output this cell to a word file

Within excel, use copy and then paste special -> values into another cell. Then copy that new cell and paste into word

eoinf wrote:

just remebered one thing some of these excel files will be read only so i wont be able to use the function on that particular file

Put the functions in a new file and link to the read only file