• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

concatenation question

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
rutgermons
Asked:
rutgermons
1 Solution
 
barry houdiniCommented:
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
 
SharathData EngineerCommented:
Or

=$B$3&C3&B3
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now