Add dashes to fractions in html

[plank22]

Over 3K rows ---- Is there a way to add dashes to fractions

Example

Please Login or Register  to view this content.

Would like

Please Login or Register  to view this content.

[sandy666]

I assume your data start in A1, so try in B1:

Please Login or Register  to view this content.

[plank22]

Hi Sandy,

Thank you for your help.Worked on only the first bullet point. Here are the results.

Please Login or Register  to view this content.

[sandy666]

This is a result of the same formula:

Please Login or Register  to view this content.

You can try this one:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

but if you have something different than space (CHAR(32) you need to know what is it.

attach example file with more data what will be more representative.

[plank22]

Tried no luck

File attached

[sandy666]

Could you tell me how you paste all code into excel? I copied and paste it from your post and have every code line in different row. One line - one row.

[plank22]

Just copied and pasted the entire column. There are returns in the code in the rows.

[sandy666]

I copied your column and use Text Import Wizard. Formula works. See attachemnt.
Btw. If you want your way you need look for VBA soultion I think.

[plank22]

All items in the column and row that were in one row are now in different rows.

[sandy666]

Try this way:
1. On sheet1 where <ul><li>xxx</li> ....</ul> is in one cell in B1 type =TRIM(A1) and drag down.
2. Select column B, Copy
3. Create text document (Notepad) and open
4. Paste into text document
5. Select all in text document and copy
6. Create new sheet in you excel file, say sheet2
7. On sheet2 select A1 and from the menu bar select Paste=>> Text Import Wizard , remove all checks there, Next, Finish
8. On Sheet2 in B1 paste formula: =IFERROR(REPLACE(A1,SEARCH(" ? ",A1)+2,1,"-"),A1) and drag down

[sandy666]

Thanks for rep but you forgot mark thread solved (if solved)

[plank22]

I tried this but when I import the info it is no longer in the same rows as before.

Example:

Row 1 has <ul>
Row 2 has <li>Hardware: Grace Pull 3 3/4 Inch</li>
And so on

I need all info that was in row one to still be in row one on the import. I did try it and it add the dashes to all but I still cant use the data.

[sandy666]

So, result is ok because you got what you wanted.
Use data is the second problem. Why, how and where you want it to use?

[plank22]

That column and all its rows are part of a larger spreadsheet that has to match up exactly the way it was taken out as each row is part of different product. Why it did work, I cant use it unless it is put back exactly where I got it.

I do appreciate your help but I still do not understand why there is no script of formula that will do it the way it is?

[sandy666]

Excel is not a God. Excel is a puzzle. Only you know what you really want (I don't see it in your description).
You got what you want from 1st post. Now if you have next problem you need start new thread and type there detailed description with samples.xlsx. Of course, if it applies to excel.

edit:
btw. if you want use result from excel in html file, copy result and paste into html because html is a normal txt file with changed extesnsion, and do it on copy not on original file.

@Administrator: Sucuri CloudProxy - Backend Server timeout, Database error and so on....