Adding Spaces and Columns

[lse]

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

 

[FormR]

Like this maybe:

Excel Workbook
	A	B	C	D	E	F
1	John	B	Doe		John B Doe	10
2	Jane	Doe			Jane Doe	8
3	John	L	Doe		John L Doe	10
4	Fred	L		Smith	Fred L Smith	12
Sheet1

 

[lse]

Thank you so much. It's perfect.