Can someone please help provide the code to produce a user function which concatenates the two cells next to it.
For example in A1
=concatenate(A2,"/",A3)
I use it such a lot that I could save loads of click time if I had a custom function for it.
Thanks
Tdub
Terry
"... I thought I was a power user of Excel until I came onto these boards..."
May be textjoin function can do it
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Doesn't that function, by virtue o the fact that the cell references are relative, do exactly what you want?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks