Hi,
It's been awhile since I've worked with forumulas and I'm drawing a blank on this one.
I have four columns containing names. The first two columns always have text in them, column 3 and 4 may have text.
Example:
A B C D
John B Doe
Jane Doe
John L Doe
The result needs to be John B Doe
with a count of 10 characters
I need to add a space to the end of the text string for the columns that contain data, but not the empty columns. Then I need to count the total number of characters in all columns containing text.
Thanks for the help.
Laurie
It's been awhile since I've worked with forumulas and I'm drawing a blank on this one.
I have four columns containing names. The first two columns always have text in them, column 3 and 4 may have text.
Example:
A B C D
John B Doe
Jane Doe
John L Doe
The result needs to be John B Doe
with a count of 10 characters
I need to add a space to the end of the text string for the columns that contain data, but not the empty columns. Then I need to count the total number of characters in all columns containing text.
Thanks for the help.
Laurie