Posted: 8/2/2008 2:36:26 PM EDT
|
Howdy. I need to take a spreadsheet a client gave me and use it to upload into an ecommerce program. The problem I have is this: (despite my CLEAR and EXACT instructions) Each cell can only be ONE line. There can be no returns in it. So this: ADDS FULL-FEATURED GPS NAVIGATION TO LAPTOP, POCKET PC, PDA & SMARTPHONE DEVICES WITH BLUETOOTH® WIRELESS TECHNOLOGY Need to become this: ADDS FULL-FEATURED GPS NAVIGATION TO LAPTOP,POCKET PC, PDA & SMARTPHONE DEVICES WITH BLUETOOTH® WIRELESS TECHNOLOGY Help - how do I do that? I know how to find/replace - but I don't know how to find a 'return'. |
|
Are you talking about concatenate? If would be: =concatenate(a1,a2, a3, a4) This would be if the text is typed into 4 different rows right above each other as you show. Then, you would copy and paste as text into another cell, and copy and paste to wherever you wanted to. You would likely have to add spaces between the different lines. |
|
Yeah, if all of that text is contained in one cell, then it is wrapped. It should export as one line. If you hit return while you are in a cell, it will kick you to the next cell below. If you want to unwrap the text, do this: - Click on the cell - Select Format > Cells - Select the Alignment tab - Under Text control, the "wrap text" box should be unchecked. |
I found out it could be done when I received a spreadsheet with them in it, and I was supposed to add data with the same format in a hurry. I ended up doing a copy&paste of existing data and then replacing the visible text with my new text. Slow, ugly, but got the job done. I then spent a lot of time trying to find out how to do it correctly.So I give myself a 
|