Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

table arrays

ResolvedVersion 2007

Martin has attended:
Excel Advanced course

Table arrays

Anthony was going to send me a link for table arrays that i might find usefull

RE: table arrays

Hi Martin, thanks for your query. Can you remind me of our conversation and what you need to do? Was it array formulas we were discussing?

Anthony

Tue 29 Nov 2011: Automatically marked as resolved.

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.