Solved

concatenation question

Posted on 2014-01-11
2
218 Views
Last Modified: 2014-01-12
Folks

I have a field value in row/col B3 (this is a variable though) how can I use this to concatenate with multiple other fields i.e.


=B3&C3&B3
=B3&C4&B4
=B3&C5&B5
=B3&C6&B6
=B3&C7&B7

essentially b3 remains fixed in the formula
0
Comment
Question by:rutgermons
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 39773975
You can use $ signs to produce an "absolute" reference, i.e. one that won't change when copied down, e.g. use this formula in row 3 copied/filled down

=B$3&C3&B3

regards, barry
0
 
LVL 41

Expert Comment

by:Sharath
ID: 39774234
Or

=$B$3&C3&B3
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question