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.
|