Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some excel files that I save as comma delimited text files in order to
import them into a Mysql database. However, some text cells have linebreaks in them, which results in the part after the linebreak being put onto a new line in the comma delimited text file. The mysql import script treats it as a new record, which should not be the case. So I want to make a macro that checks all the cells and removes any linebreaks in them. Can anyone show me how to do that? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i remove the 0 in the cells | Excel Discussion (Misc queries) | |||
how do I insert forced linebreaks in cells in Excel | Excel Discussion (Misc queries) | |||
how do I shift the contents of the cells up to remove empty cells. | Excel Discussion (Misc queries) | |||
Remove ' from cells | Excel Discussion (Misc queries) | |||
Remove Blank Cells within each row | Excel Programming |