Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an invoice with some wording about canceling and want to include a
name (seller) and address (residence) in the middle. Is there an easier way than the way I am doing it. I want to be able to change the name and address when necessary. What I have been doing is copying the text into several cells and deleteing parts and putting it back together from different sentence fragments. Example: Compete string: If you cancel, you must make available to the seller at your residence, ... risk. =A30&A33&LEFT(F16,FIND(" ",F16)-1)&A31&D10&A32 This finds first name, how do I find last? A30: If you cancel, you must make available to A31: at A32: , ... risk. A33: Mrs. D10: 123 Oak Street F16: Laura Smith Final reads: If you cancel, you must make available to Mrs. Smith at 123 Oak Street, ... risk. -- Thanks, Laura |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
That seems reasonable to me. The formula gets long (obvioulsy) but the
underlying approach is clear and straightforward. You might consider making it more complicated, though, by separating first and last names into separate cells.Your current formula assumes a blank space delimits the first and last names. This isn't particualrly true. / Tyla / On Mar 12, 8:31 am, lauras03 wrote: I have an invoice with some wording about canceling and want to include a name (seller) and address (residence) in the middle. Is there an easier way than the way I am doing it. I want to be able to change the name and address when necessary. What I have been doing is copying the text into several cells and deleteing parts and putting it back together from different sentence fragments. Example: Compete string: If you cancel, you must make available to the seller at your residence, ... risk. =A30&A33&LEFT(F16,FIND(" ",F16)-1)&A31&D10&A32 This finds first name, how do I find last? A30: If you cancel, you must make available to A31: at A32: , ... risk. A33: Mrs. D10: 123 Oak Street F16: Laura Smith Final reads: If you cancel, you must make available to Mrs. Smith at 123 Oak Street, ... risk. -- Thanks, Laura |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I NEED TO CAPITIALIZE MY TEXT INSIDE THE CELL...HOW? | Excel Discussion (Misc queries) | |||
How do I insert a new line of text inside a cell | New Users to Excel | |||
How to make the text inside Text Box upside down? | Excel Discussion (Misc queries) | |||
Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) | |||
Find/Replace 4 numbers in a sting of 17 | Excel Discussion (Misc queries) |