98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel concatenation?? if??
Excel concatenation?? if??
Resolved · Urgent Priority · Version 2007
Fri 4 Apr 2008, 13:58Delegate Adam said...
Adam has attended:
Excel Intermediate course
Excel concatenation?? if??
hi,
So I have a list of properties 1-96.
I have a separate workbook list of indexes 1-12.
Each property has been assigned an index, eg: prop 34=index no 7; prop 35=index 2 and so on.
how could I assign these indexes to there relevant numbers against the properties? Do I need to concatenate or something a little more involved?
Thanks for your help.
Adam
Mon 7 Apr 2008, 05:28Trainer Mara said...
RE: excel concatenation?? if??
Hello Adam,
I hope you enjoyed your Excel training session with us.
I am trying to understand more clearly what you are looking to do. If you want to create a unique property-to-index identifier, then I would do a concatenation. Is this what you would like to do? If not, could you give a bit more detail? I will try to help further.
Have a great day.
Regards,
Mara
Microsoft Office Specialist Master Trainer
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Toggle Formulas and ResultsCtrl + 'The key above Tab with the |
