Hi
What are the advantages of using Concatenate compared to "&", I have only just realised Concatenate can do a similar thing to "&" which I have always used in the past.
Regards
Hi
What are the advantages of using Concatenate compared to "&", I have only just realised Concatenate can do a similar thing to "&" which I have always used in the past.
Regards
As far as I know, there is no difference. I cant remember the last time I used CONCATENATE(), I always use &...less to type and makes reading formulas that use it, easier
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
As far as I know, you can save the space (Length) of the formula by using &
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
if you really want to concatenate can be done completely by mouse clicks
but like fdibbins use & most of the time as it is easier to use ...for shorter combinations
if i go over 7 i would go to the effort of using concatenate
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks