software

trying to set up a file with information for electronic transfer of data.
The columns needs to be set at specific width, so I need to be able to add
spaces before text, i.e. quot; leftquot;. Is there a way to do this without
having to manually add spaces?

Not sure what this has to do with the width of the column, but if you need
the cell to contain a certain number of characters, say 30, you could try
something like this:

=REPT(quot; quot;, 30 - LEN(B8)) amp; B8

You may want to use a helper column and then afterwards do a copy/paste
special values.
If you just need the column width to be a certain number, select the column,
and hit format column width and type the number you need it to be.

--
Kevin Vaughnquot;grammyquot; wrote:

gt; trying to set up a file with information for electronic transfer of data.
gt; The columns needs to be set at specific width, so I need to be able to add
gt; spaces before text, i.e. quot; leftquot;. Is there a way to do this without
gt; having to manually add spaces?

Hi

Am best you separate data entry and transfer data. On input sheet, enter all
values aot padded. On transfer sheet, calculate values from according cells
on input sheet - like:
=IF(Input!A2=quot;quot;,quot;quot;,RIGHT(REPT(quot; quot;,20) amp; Input!A2,20))Arvi Laanemets
quot;grammyquot; gt; wrote in message
...
gt; trying to set up a file with information for electronic transfer of data.
gt; The columns needs to be set at specific width, so I need to be able to add
gt; spaces before text, i.e. quot; leftquot;. Is there a way to do this
without
gt; having to manually add spaces?
Thanks, this is exactly what I needed.

quot;Kevin Vaughnquot; wrote:

gt; Not sure what this has to do with the width of the column, but if you need
gt; the cell to contain a certain number of characters, say 30, you could try
gt; something like this:
gt;
gt; =REPT(quot; quot;, 30 - LEN(B8)) amp; B8
gt;
gt; You may want to use a helper column and then afterwards do a copy/paste
gt; special values.
gt; If you just need the column width to be a certain number, select the column,
gt; and hit format column width and type the number you need it to be.
gt;
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;grammyquot; wrote:
gt;
gt; gt; trying to set up a file with information for electronic transfer of data.
gt; gt; The columns needs to be set at specific width, so I need to be able to add
gt; gt; spaces before text, i.e. quot; leftquot;. Is there a way to do this without
gt; gt; having to manually add spaces?

You're welcome. Glad it worked for you.
--
Kevin Vaughnquot;grammyquot; wrote:

gt; Thanks, this is exactly what I needed.
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt; gt; Not sure what this has to do with the width of the column, but if you need
gt; gt; the cell to contain a certain number of characters, say 30, you could try
gt; gt; something like this:
gt; gt;
gt; gt; =REPT(quot; quot;, 30 - LEN(B8)) amp; B8
gt; gt;
gt; gt; You may want to use a helper column and then afterwards do a copy/paste
gt; gt; special values.
gt; gt; If you just need the column width to be a certain number, select the column,
gt; gt; and hit format column width and type the number you need it to be.
gt; gt;
gt; gt; --
gt; gt; Kevin Vaughn
gt; gt;
gt; gt;
gt; gt; quot;grammyquot; wrote:
gt; gt;
gt; gt; gt; trying to set up a file with information for electronic transfer of data.
gt; gt; gt; The columns needs to be set at specific width, so I need to be able to add
gt; gt; gt; spaces before text, i.e. quot; leftquot;. Is there a way to do this without
gt; gt; gt; having to manually add spaces?

Kevin, this justifies the data to the right. What do I change to justify it
to the left?

quot;Kevin Vaughnquot; wrote:

gt; You're welcome. Glad it worked for you.
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;grammyquot; wrote:
gt;
gt; gt; Thanks, this is exactly what I needed.
gt; gt;
gt; gt; quot;Kevin Vaughnquot; wrote:
gt; gt;
gt; gt; gt; Not sure what this has to do with the width of the column, but if you need
gt; gt; gt; the cell to contain a certain number of characters, say 30, you could try
gt; gt; gt; something like this:
gt; gt; gt;
gt; gt; gt; =REPT(quot; quot;, 30 - LEN(B8)) amp; B8
gt; gt; gt;
gt; gt; gt; You may want to use a helper column and then afterwards do a copy/paste
gt; gt; gt; special values.
gt; gt; gt; If you just need the column width to be a certain number, select the column,
gt; gt; gt; and hit format column width and type the number you need it to be.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Kevin Vaughn
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;grammyquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; trying to set up a file with information for electronic transfer of data.
gt; gt; gt; gt; The columns needs to be set at specific width, so I need to be able to add
gt; gt; gt; gt; spaces before text, i.e. quot; leftquot;. Is there a way to do this without
gt; gt; gt; gt; having to manually add spaces?

Try this one instead:

=B8 amp; REPT(quot; quot;, 30 - LEN(B8))

This will put the spaces at the end.
--
Kevin Vaughnquot;grammyquot; wrote:

gt; Kevin, this justifies the data to the right. What do I change to justify it
gt; to the left?
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt; gt; You're welcome. Glad it worked for you.
gt; gt; --
gt; gt; Kevin Vaughn
gt; gt;
gt; gt;
gt; gt; quot;grammyquot; wrote:
gt; gt;
gt; gt; gt; Thanks, this is exactly what I needed.
gt; gt; gt;
gt; gt; gt; quot;Kevin Vaughnquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Not sure what this has to do with the width of the column, but if you need
gt; gt; gt; gt; the cell to contain a certain number of characters, say 30, you could try
gt; gt; gt; gt; something like this:
gt; gt; gt; gt;
gt; gt; gt; gt; =REPT(quot; quot;, 30 - LEN(B8)) amp; B8
gt; gt; gt; gt;
gt; gt; gt; gt; You may want to use a helper column and then afterwards do a copy/paste
gt; gt; gt; gt; special values.
gt; gt; gt; gt; If you just need the column width to be a certain number, select the column,
gt; gt; gt; gt; and hit format column width and type the number you need it to be.
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Kevin Vaughn
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;grammyquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; trying to set up a file with information for electronic transfer of data.
gt; gt; gt; gt; gt; The columns needs to be set at specific width, so I need to be able to add
gt; gt; gt; gt; gt; spaces before text, i.e. quot; leftquot;. Is there a way to do this without
gt; gt; gt; gt; gt; having to manually add spaces?