Finding Blank Spaces between text

[winskirst]

I need to find data in two different formats within a column

Examples

Webb Christopher


Greer Nancy

I need to find cells with text that have more than one space between the first and last names; and cells with text that have only one space between the first and last names.

I am fairly new to excel. I can find the space after the first word but cannot tell it to find ones that say have a space then another string of text.

Thank you for your help!
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[winskirst]

@ Delmar - Yes, My options are set to calculate automatically. That is exactly what I did. I pasted into one cell and dragged the formula down. I checked and the cell references are correct. I also tried F9, but that didn't change anything. Thanks.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[winskirst]

@Delmar - The cell references were not correct! I feel like a dunce. Your formula worked. Thanks so much. I am learning from this too. Thanks.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Darren Bartrup]

Cool. Glad you got there in the end.

 

[winskirst]

Thank you for everyone's help today.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[winskirst]

Thanks Delmar. Like your profile photo too.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Scott Huish]

Will TRIM remove spaces between words though?

Trim doesn't remove all spaces between words, it reduces spaces between words to a single space.

 

[winskirst]

Thank you HotPepper. Since Trim removed the extra spaces, and I didn't want that, I thought it wouldn't work, but it does.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Darren Bartrup]

Like your profile photo too.

Thanks. About time I put a new one up really. Got a good one of me getting my throat slit in a fight somewhere.

 

[Jana.Luo]

Hi there, I have got a similar situation here for addresses, but a bit more complicated. They use 2spaces as a diameter. The data looks like this below, in A is the raw data, in B, C, D is the result I wanted, can you please help me out there? Thanks very much!

A B C D

19 YULE PLACE 19 YULE PLACE MASSEY AUCKLAND 0614
MASSEY
AUCKLAND 0614



1 HAMILTON ROAD 1 HAMILTON ROAD WAIMAUKU 0881
WAIMAUKU 0881

 

[Scott Huish]

So there are single spaces between the words and double spaces between the items?