I just want to get rid of a space between a first name and a last name, but I want to keep the space between the first name and the middle name (for the ones with middle name). The fourmula that I use get rid of all the spaces. That doesn't work with my case ( cause the other column that I want to use in vlookup function formula is set up with the space between the first name and middle name). Would please let me how to modify the formula to get the desired result?
This is the formula I am using now =Substitute(A1," ","")
<TABLE style="WIDTH: 140pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=186><COLGROUP><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 6802" width=186><TBODY><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 140pt; HEIGHT: 13.5pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl65 height=18 width=186>Mulligan, Ruth K</TD></TR></TBODY></TABLE>
.
Desired result - Mulligan,Ruth K
This is the formula I am using now =Substitute(A1," ","")
<TABLE style="WIDTH: 140pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=186><COLGROUP><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 6802" width=186><TBODY><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 140pt; HEIGHT: 13.5pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 1pt solid" class=xl65 height=18 width=186>Mulligan, Ruth K</TD></TR></TBODY></TABLE>
.
Desired result - Mulligan,Ruth K