Hello, new to the fourm, my spelling is horrible and I will get straight to the question.
I have three (very long collumes). The first collume is just the equipment number. The second has numbers repersenting other information (aka 1 means to inspect). The third collume is the time peirod that you need to do the thing in the first collume (aka every 2 weeks or daily).
The problem is each cell has mutliple line breaks in it. For example one cell may look like this
1,3,5
2,7
1-4 & 8
and the cell beside it may look like this
weekly
daily
*note there are spaces in the second collume...
My goal is to have someone say we recived this equipemtn (aka a check box or something) and for the computer to make a calender of what days what equipment needs to be maintained.
I was using the code InStr(check + 1, Cell, ",", 1) before when i had everything separted in a differnt collume by commas, and this would tell me where the differnt strings started and ended. I then used Mid(Cell, check + 1, fun - 1) to grab that string (the variable are not that important here).
My big problem is i have no way of telling the code to stop at line breaks like i did with the commas.
I am looking for a way to maybe make a seimi colan after each line break, which i don't want to do manual being there is 1400 rows with an average of about 2 breaks per row and also two collumes. I tried using the list part of excel, but i am extreamly sketchy on it and it doesn't like blank line breaks. I also tried "Delimated" but it misses the spaces also. I would prefer just to use code also
Anyway, any help will be greatly appreated!
Sorry horrible spelling
Kavy
I have three (very long collumes). The first collume is just the equipment number. The second has numbers repersenting other information (aka 1 means to inspect). The third collume is the time peirod that you need to do the thing in the first collume (aka every 2 weeks or daily).
The problem is each cell has mutliple line breaks in it. For example one cell may look like this
1,3,5
2,7
1-4 & 8
and the cell beside it may look like this
weekly
daily
*note there are spaces in the second collume...
My goal is to have someone say we recived this equipemtn (aka a check box or something) and for the computer to make a calender of what days what equipment needs to be maintained.
I was using the code InStr(check + 1, Cell, ",", 1) before when i had everything separted in a differnt collume by commas, and this would tell me where the differnt strings started and ended. I then used Mid(Cell, check + 1, fun - 1) to grab that string (the variable are not that important here).
My big problem is i have no way of telling the code to stop at line breaks like i did with the commas.
I am looking for a way to maybe make a seimi colan after each line break, which i don't want to do manual being there is 1400 rows with an average of about 2 breaks per row and also two collumes. I tried using the list part of excel, but i am extreamly sketchy on it and it doesn't like blank line breaks. I also tried "Delimated" but it misses the spaces also. I would prefer just to use code also
Anyway, any help will be greatly appreated!
Sorry horrible spelling
Kavy
