Column display-excel 2007

[Guest]

I regularly download and print local business listings. Their business phone
# column reads "business phone #" 000-000-0000. I wish to eliminate the words
to narrow the column for printing purposes, how can I do this? and can I
format excel to remember this setting for future downloads?

I appreciate any help on this.

 

[Bernard Liengme]

Let's say the first one is in D1

Solution 1
Inset a new blank column after D
In the new E1 enter =RIGHT(D1,12)
Copy this down the column (quickest way - double click fill handle which is
the small solid square on bottom right of active cell's border)
Select all the new stuff in column E; use Copy; with it still selected use
Edit | Paste Special and specify Values
Now you can delete the column D
You could record a macro to do this each time


Solution 2
If the text is real as shown and the same in all cells:
Use Data | Text to Column, specify Fixed width and drag the split line to
just before the first digit
You shown insert a new column first if there is stuff in column E
best wishes

 

[Guest]

Thank you this solved my problem.

Let's say the first one is in D1

Solution 1
Inset a new blank column after D
In the new E1 enter =RIGHT(D1,12)
Copy this down the column (quickest way - double click fill handle which is
the small solid square on bottom right of active cell's border)
Select all the new stuff in column E; use Copy; with it still selected use
Edit | Paste Special and specify Values
Now you can delete the column D
You could record a macro to do this each time


Solution 2
If the text is real as shown and the same in all cells:
Use Data | Text to Column, specify Fixed width and drag the split line to
just before the first digit
You shown insert a new column first if there is stuff in column E
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email