Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default using a formula inside a sting of text

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default using a formula inside a sting of text

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I NEED TO CAPITIALIZE MY TEXT INSIDE THE CELL...HOW? Capitalization Excel Discussion (Misc queries) 5 May 30th 07 07:01 AM
How do I insert a new line of text inside a cell thudson New Users to Excel 4 April 3rd 06 07:08 PM
How to make the text inside Text Box upside down? Kataro Excel Discussion (Misc queries) 1 December 21st 05 04:38 PM
Need macro to insert text string while inside cell (formula) BrianB Excel Discussion (Misc queries) 0 May 31st 05 04:18 PM
Find/Replace 4 numbers in a sting of 17 Lisa Excel Discussion (Misc queries) 4 January 5th 05 11:40 PM


All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"