Concat is another way

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I did not know the ampersand worked that way--pretty cool-
-I've always done this with the concatenate function,
which in this case would be

=concatenate("1",A1)

Regards,
Peter
 
I have a hard time even remembering the word concatenate so I rather use the
ampersand instead :))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concatenate entries from a column into a cell by logical AND withanother column 2
concatenate values 4
How to pass variables as arguments of a function 1
concatenate in array formula? 1
How to concatenate many rows in Excel 2
Constructing Range Name calls with Concatenate 4
Concatenate question on limitations 4
Format Bold - Only Part of a Function 3

Back
Top