excel concatenation if
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel concatenation?? if??

Excel concatenation?? if??

resolvedResolved · Urgent Priority · Version 2007

replyReply 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

For upcoming training course dates see: Pricing & availability

replyReply 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

 

Please browse our web site to find out more about
exce+training and other Microsoft training courses.

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard