I want replace all dash to cell in a paragraph

[vengatvj]

See my attached file

a paragraph has many dash. I want a cell in every dash to make a function. I tried it myself. but it was look bad. paragraph not distributed evently

[FDibbins]

Because of the language you are using, it is very hard for me to see what you are doing, and where you a splitting this - can you give more details please?

[MarvinP]

Perhaps your "Dash" is really Char(95) ??

Try to Substitute(Each Cell, Char(95),"") ??

[vengatvj]

This is summon to unpaid customers,
Presently we are print this document and fill the dash using our handwriting. I want avoid handwriting. if a cell available instead of dash, then i can make (=) function in that cell. I have a data in another sheet. I need to do this for many customers

[vengatvj]

Sorry am not expert in excel. could you tell me clearly what is char(95)?

[mohan.r1980]

try this

Please Login or Register  to view this content.

[vengatvj]

I WANT MAKE A FUNCTION IN A PARAGRAPH. SEE THIS SAMPLE FILE.
A PARAGRAPH GIVEN IN A1 CELL, SOME DETAILS GIVEN IN B2, B3, B4 CELLS. I WANT FILL THAT DATA IN THE PARAGRAPH. is there any formula to fill in dash?
This is sample file.
I have a large paragraph with many dash. i need to fill every dash.

[FlameRetired]

Try this in B1 and fill across until you get blanks.

Please Login or Register  to view this content.

• I was unable to do this all in a one-cell formula. It builds left to right.
• The result you want is in the last cell that has output ... in this case D1.
• This formula only works because the number of "_" characters in the dashes in this example are never more than 15. It would not work if there were more.
• If this method is acceptable to you I recommend standardizing the length of each dash to the same number of "_" characters.
• Otherwise this formula will have unpredictable results.