If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing data with tabs
We are trying to help our neighbor publish some documents she has been
working on but am having trouble dealing with multiple tabs she sometimes uses between columns. She is using WORD with the layout per single row is as follows. 1.(space)phrase 1(tab)phrase 2(tab)phrase 3 however, some the rows have multiple tabs between the phrases 1.(space)phrase 1(tab,tab)phrase 2(tab,tab)phrase 3 After copying/paste the text into Excel (2003) from the WORD doc, I have to select all the empty cells that the extra tab created and delete them. Does anyone know of a way to do this selecting/deleting with a function or macro OR is there another way to import this data to remove the extra tab characters. Thanks to all.... |
Thread Tools | |
Display Modes | |
|
|