ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Embedding a space within footer (https://www.excelbanter.com/excel-discussion-misc-queries/127678-embedding-space-within-footer.html)

wnfisba

Embedding a space within footer
 
I have the following in my worksheet footer...

&[Path]&[File]&[Tab]

Is there any way to embed a space in between to make it a little more
readable???

Thanks in advance for your help.

wnfisba

Dave F

Embedding a space within footer
 
Just enter a space as if you're typing text.
--
Brevity is the soul of wit.


"wnfisba" wrote:

I have the following in my worksheet footer...

&[Path]&[File]&[Tab]

Is there any way to embed a space in between to make it a little more
readable???

Thanks in advance for your help.

wnfisba


SteveW

Embedding a space within footer
 
Yes it's that big bar at the bottom of a keyboard

It works fine, try it.

Steve

On Thu, 25 Jan 2007 16:19:03 -0000, wnfisba
wrote:

I have the following in my worksheet footer...

&[Path]&[File]&[Tab]

Is there any way to embed a space in between to make it a little more
readable???

Thanks in advance for your help.

wnfisba


SteveW

Embedding a space within footer
 
I wonder whether posters try before asking.

Groups like this used to expect readers to be lurkers before they posted..
I love the questions, but wonder why they haven't tried something first :)

To be fair the poster might have tried space or something and it didn't
work.

But then it would be better if they said so and explained what they tried


Steve

On Thu, 25 Jan 2007 16:26:03 -0000, Dave F
wrote:

Just enter a space as if you're typing text.


Gord Dibben

Embedding a space within footer
 
&[Path]&[File]& &[Tab]


Gord Dibben MS Excel MVP


On Thu, 25 Jan 2007 08:19:03 -0800, wnfisba
wrote:

I have the following in my worksheet footer...

&[Path]&[File]&[Tab]

Is there any way to embed a space in between to make it a little more
readable???

Thanks in advance for your help.

wnfisba



SteveW

Embedding a space within footer
 
That actually doesn't work with Excel 2000

Space on it's own is fine, why put & in front ?

Steve

On Thu, 25 Jan 2007 17:47:21 -0000, Gord Dibben <gorddibbATshawDOTca
wrote:

&[Path]&[File]& &[Tab]


Gord Dibben MS Excel MVP


On Thu, 25 Jan 2007 08:19:03 -0800, wnfisba

wrote:

I have the following in my worksheet footer...

&[Path]&[File]&[Tab]

Is there any way to embed a space in between to make it a little more
readable???

Thanks in advance for your help.

wnfisba



All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com