Adding text to a value in another sheet

Question

Hi ,

I have data in the field =INPUT!C42.

I want to preface this data with a letter C

what is the best way of doing this?

Answer 1

="C"&INPUT!C42

If you want to suppress this if INPUT!C42 is blank:

=IF(INPUT!C42="", "", "C"&INPUT!C42)

Answer 2

Hi Hans,

This worked perfectly.

Thank you for your help yet again!

Answer 3

Hello 

Good day! I hope you're doing well! 

It has been a while and i am writing to see how things are going with this issue. Have you had a chance to check the reply provided? Are you encountering any difficulties when trying my suggestion. Please feel free to let me know if there’s anything I can assist you with. 

Thank you for your valuable time. 

Best Regards, 
Allison  - MSFT | Microsoft Community Support Specialist.

Answer 4

Hello 

Thank you for reaching out to the Microsoft Community. 

Regarding to your question, I suggest you to try: 

First, Linking Cells Between Two Excel Files 

1. Open Both Workbooks:  
   • Open the source workbook (where the data is coming from).
   • Open the destination workbook (where you want the data to appear).
2. Use a Formula to Link:  
   • In the destination workbook, click on the cell where you want the linked value.
   • Type = and then switch to the source workbook.
   • Click the cell you want to link to.
   • Press Enter.

Excel will automatically create a formula like: =[INPUT.xlsx]Sheet1!$C$42 

1. Save Both Files:  
   • Make sure both files are saved so the link remains active.
2. Keep Files Together:  
   • If you move the files, Excel may lose the link unless both files are accessible

Next, usingAutoCorrect 

Go to File > Options > Proofing. 

1. Click AutoCorrect Options.
2. In the Replace box, type "C".
3. In the With box, enter =[INPUT.xlsx]Sheet1!$C$42.
4. Click Add > OK.

Now, whenever you type "C" and press Enter, it will auto-replace with "=[INPUT.xlsx]Sheet1!$C$42" 

If you've tried the suggested solutions but it cannot meet your requirement, please let me know if there are any updates or changes in behavior. Your feedback will help me provide further support and explore additional solutions tailored to your situation. I am here to assist you! 

Thank you for your valuable time. 

Best Regards, 
Allison  - MSFT | Microsoft Community Support Specialist.