Insert cell with text within cell that has large amount of text(non formula)

**paxile2k** · 04-11-2011, 08:22 PM

I have a cell that has a large amount of text in a non formula. One of the statements i trying to modify to reference another cell that has text, that adjusts based on other conditions. here is an example:

Test Header

this is letting you know you have (xx months) to make a choice on the issue
by not doing it, you could have some issues in the future regarding the matter
please response, some more addition text

Do you understand?

since it is not in a formula format, it is making it harder to have/replace part of the text. What i am trying to do is to have the (xx months) replaced with a cell reference within the text of the cell that is not in a formula format, so (xx months) = "&Sheet1!A1&" which in other conditions is and has worked fine, but not sure on a cell that has text in a non formual format. Is this even possible? I have tried to break apart each line to individual cells, which works with the char(10) between each line if both a = or concatenate forumual, however it removed formating of the text (ie bold/underline, etc)

**bentleybob** · 04-11-2011, 08:27 PM

Please Login or Register  to view this content.

Where your variable is (in this case) in cell A1. Then use word wrap in your cell to get the line breaks where they're appropriate.

**paxile2k** · 04-11-2011, 08:29 PM

Originally Posted by bentleybob

Please Login or Register  to view this content.

Where your variable is (in this case) in cell A1. Then use word wrap in your cell to get the line breaks where they're appropriate.

Thankyou for your reponse, some of the formatting of the text included a bullet list and carriage returns, which i am removing and replacing with just a *, but trying to add the = gives me an error (formula is too long)

**bentleybob** · 04-11-2011, 08:33 PM

So why not put the bulk of the text on one line, below the line with your cell reference. So the first line is, say,

Please Login or Register  to view this content.

and the next line(s) is/are just tet with the rest of the dialogue.

**paxile2k** · 04-11-2011, 08:41 PM

Originally Posted by bentleybob

So why not put the bulk of the text on one line, below the line with your cell reference. So the first line is, say,

Please Login or Register  to view this content.

and the next line(s) is/are just tet with the rest of the dialogue.

its inclusive with the rest of the text because of verbage that needs to take place before, would the concatenate/="insert text here" option be used and preserve formatting, such as bold/underline, etc? the only other option i found is the break it down line by line but i lose the formatting

Insert cell with text within cell that has large amount of text(non formula)

LinkBack

Thread Tools

Rate This Thread

Display

Insert cell with text within cell that has large amount of text(non formula)

Re: Insert cell with text within cell that has large amount of text(non formula)

Re: Insert cell with text within cell that has large amount of text(non formula)

Re: Insert cell with text within cell that has large amount of text(non formula)

Re: Insert cell with text within cell that has large amount of text(non formula)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions