Excel Formual

RA AS 1 Reputation point
2022-03-21T19:08:23.207+00:00

Hi there

I need help with a formula in excel

I am getting a price feed with the following formula =RTD("pipes.rtd",,"QUOTES","Mark",".AMZN230120P3000",) in to excel
and I'd like to change this section ".AMZN230120P3000"

Instead of ".AMZN230120P3000" I'd like to have AMZN in cell A2, 230120 in B2, P in C2 and 3000 in D2

By changing this ".AMZN230120P3000" to something like A2, B2, C2, D2 My goal is to get the formula to read this section ".AMZN230120P3000" off of the cells

That way, if I need to change one of the inputs I can just change one of the cells

As you can see on the screen shot below cell E2 has the following formula =RTD("pipes.rtd",,"QUOTES","Mark",".AMZN230120P3000",)

I need to remove ".AMZN230120P3000" and instead have that part be fed by Cells A2, B2, C2 and D2

How do I do this?

I tried comma's and didn't work

Would very much appreciate your support

=RTD("pipes.rtd",,"QUOTES","Mark",A2,B2,C2,D2,)

185327-image.png

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,580 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,659 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 22,396 Reputation points Microsoft Vendor
    2022-03-22T02:11:44.52+00:00

    Hi @RA AS ,
    You can use CONCATENATE function to help you:

    =RTD("pipes.rtd",,"QUOTES","Mark",CONCATENATE("""."&A2&B2&C2&D2&""""),)  
    

    185432-109.png

    Hope the information is helpful.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.