Solved

concatenation question

Posted on 2014-01-11
2
188 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
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 40

Expert Comment

by:Sharath
ID: 39774234
Or

=$B$3&C3&B3
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel ODBC connection error 3 31
highlight duplicate entry 16 29
excel connection properties parameters grayed out 5 26
Dynamic Filter ? 4 12
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

911 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now