Hi
I wonder if anyone could give me a bit of advice on a formula please.
I am using the formula below to ensure that certain surnames have a space between them, however it is also adding a space after the hyphen in double barrelled surnames.
I am trying to put a space between Van and Kempen.
The formula I am using is - =REPLACE(B2, 1+MIN(FIND(CHAR(64+COLUMN($B$2:$Z$2)),MID(B2,2,255)&(CHAR(64+COLUMN($B$2:$Z$2))))), 0, " ")
Thank you in anticipation.
I wonder if anyone could give me a bit of advice on a formula please.
I am using the formula below to ensure that certain surnames have a space between them, however it is also adding a space after the hyphen in double barrelled surnames.
I am trying to put a space between Van and Kempen.
The formula I am using is - =REPLACE(B2, 1+MIN(FIND(CHAR(64+COLUMN($B$2:$Z$2)),MID(B2,2,255)&(CHAR(64+COLUMN($B$2:$Z$2))))), 0, " ")
Thank you in anticipation.