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:

Please Login or Register  to view this content.

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

Formula:

Please Login or Register  to view this content.

**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