I have a formula importing text from another cell. I want to be able to edit this imported text.
How can I do it without copying and pasting into a new cell the result?
I have a formula importing text from another cell. I want to be able to edit this imported text.
How can I do it without copying and pasting into a new cell the result?
Go into your formulas and look at the text ones. Left, len, right, mid, char etc.
When I'm editing text, I'll usually do it sequentially across a few cells (one cell per step) so I can see what it's doing to make sure I get it right. Invariably, there will be something I didn't see or anticipate correctly regarding the text.
I don't think that there's a way to do this:
If I understand what you are after, it should be pretty easy, you just embed the formula into the other formula.
Let's say you have a simple spreadsheet with uppercase text in cell A1. Then you have some formulas - one in B1 imports the text, with a formula like "=left(A1,8)." This would bring in the leftmost 8 characters from cell A1 into B1. Then in C1 you have a formula "=lower(B1)." This would take the characters in B1 and display them in C1 as lower case.
Instead, you could embed both formulas into B1 as "=lower(left(A1,8))." Then you have one cell which does both things, brings in the left 8 characters and displays them as lower case. Does that help at all?
You'll need to log in to post.
