Replace underscore with a space in formatting

**Arismac** · 07-09-2015, 12:00 AM

Is it possible to replace the Underscore in INVOICE B10 and D33 with a Space?

**FDibbins** · 07-09-2015, 12:04 AM

Try these...
B10=SUBSTITUTE(VLOOKUP($K$5,Customers,4,FALSE),"_"," ")
D33=LEFT(B10,LEN(B10)-5)

**quekbc** · 07-09-2015, 12:07 AM

Encase the formula in B10 with a SUBSTITUTE function.
I.e.

Formula:

=SUBSTITUTE(VLOOKUP(R5C11,Customers,4,FALSE),"_"," ")

However, in doing so, the formula in D33 will have to be adjusted. Using the same logic, change D33 to...

Formula:

=LEFT(B10,FIND("@",SUBSTITUTE(B10," ","@",LEN(B10)-LEN(SUBSTITUTE(B10," ",""))))-1)

**Arismac** · 07-09-2015, 12:20 AM

Many thanks Gentlemen. My first introduction to SUBSTITUTE. I have much to learn, thank you for helping me.

Re: Replace underscore with a space in formatting