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.... |
#2
|
|||
|
|||
Importing data with tabs
Jack Deuce wrote:
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.... First, select all of your data (after the paste into Excel). Edit / Go To / Special / Blanks / OK. Edit / Delete / Shift Cells Left / OK. |
#3
|
|||
|
|||
Importing data with tabs
On Thu, 11 Feb 2010 11:19:11 -0600, Glenn wrote:
Jack Deuce wrote: 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.... First, select all of your data (after the paste into Excel). Edit / Go To / Special / Blanks / OK. Edit / Delete / Shift Cells Left / OK. Thank you. That really saves a lot of time. |
#4
|
|||
|
|||
Importing data with tabs
Jack Deuce wrote:
On Thu, 11 Feb 2010 11:19:11 -0600, Glenn wrote: Jack Deuce wrote: 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.... First, select all of your data (after the paste into Excel). Edit / Go To / Special / Blanks / OK. Edit / Delete / Shift Cells Left / OK. Thank you. That really saves a lot of time. You're welcome. Glad I could help. |
Thread Tools | |
Display Modes | |
|
|