Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi there,
I have a column where the data is displaying on separate lines within each cell. I would like the data to display on one line. As an example: "Shed a little light in your office or study with this amazing dual table lamp from Gregor, featuring florescent bulbs and an adaptive socket. Stylish design, great in any room Twin pole lamp Innovative on/off pull chain design Polished steel finish White fabric shade" All of this data is in one cell and I need it to be on one line within the cell. The tabs are messing up a report that is running with tabs as the delimeter as the report is adding each line as a separate delimeter column. As I have 10,000 cells of data I do not want to have to go into each cell manually. Is there a function or format I can use to remove the tabs and have the data display as one line? Thanks so much in advance, Zev |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Gathering Data from various tabs | Excel Worksheet Functions | |||
Removing a blank cell between data | New Users to Excel | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions |