Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# concatenation question

Posted on 2014-01-11
Medium Priority
226 Views
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
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

LVL 50

Accepted Solution

barry houdini earned 2000 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

ID: 39774234
Or

=\$B\$3&C3&B3
0

## Featured Post

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
###### Suggested Courses
Course of the Month11 days, 19 hours left to enroll