Excel formula development in the real world

Short Description
Excel formula development in the real world. Name field reconcatenation in Excel explained through building. worksheet formulae and custom VBA functions. …

Website: www.grbps.com | Filesize: 99kb

Content
. Ray Blake, GR Business Process Solutions Page 1
Excel formula development in the real world
Name field reconcatenation in Excel explained through building
worksheet formulae and custom VBA functions.
There must have been times for all of us when we’ve been presented with a
large database containing people’s names and other data which needs to be
manipulated or reported on in some way, probably in alphabetical order. As the
records appear in Excel for the first time, the heart sinks as the first column
contains the names:
John Smith
Kevin Adams
-etc
I think that 9 out of 10 such lists I am given contain a name field formatted in
this way, first name first. On the other hand, 9 out of 10 clients want their
analyses presented in alphabetical order by surname. If you often find yourself
in the same boat, this article will help you. We shall start by constructing an
Excel worksheet formula to reverse the first name and surname positions in the
field. Then we’ll work to expand the function so that it can deal easily with
initials, multiple forenames or any combination of these features. Finally, we’ll
consider the potential disadvantages of such…