Limiting Characters in a cell and adding spaces to fill the remain
 

Sorry not sure if subject title is clear.

I need to have only 15 characters in a cell. If the characters in a cell are
less than 15.. i need there to be spaces after the characters to make up 15
in total.

Does this make sense ? can it be done ?

Thanks
Mel

Limiting Characters in a cell and adding spaces to fill theremain
 

Assuming that column A contains all the information you can create
column B as per your mail by using the following fomula in cell B1 and
copying it subsequent rows
=IF(LEN(A1)<15,A1&REPT(" ",15-LEN(A1)),LEFT(A1,15))


On Jan 11, 5:57*am, Melissa wrote:
Sorry not sure if subject title is clear.

I need to have only 15 characters in a cell. If the characters in a cell are
less than 15.. i need there to be spaces after the characters to make up 15
in total.

Does this make sense ? can it be done ?

Thanks
Mel

Limiting Characters in a cell and adding spaces to fill the remain
 

Can you use a formula in another cell?

=left(a1&rept(" ",15),15)

This will truncate the value in A1 if the length is greater than 15, too.


Melissa wrote:

Sorry not sure if subject title is clear.

I need to have only 15 characters in a cell. If the characters in a cell are
less than 15.. i need there to be spaces after the characters to make up 15
in total.

Does this make sense ? can it be done ?

Thanks
Mel

--

Dave Peterson

Limiting Characters in a cell and adding spaces to fill the re
 

Thanks for the quick reply.

How do i check that it has worked. It is showing the result in a new cell
but how do i turn it from a formula to just characters



"Ag" wrote:

Assuming that column A contains all the information you can create
column B as per your mail by using the following fomula in cell B1 and
copying it subsequent rows
=IF(LEN(A1)<15,A1&REPT(" ",15-LEN(A1)),LEFT(A1,15))


On Jan 11, 5:57 am, Melissa wrote:
Sorry not sure if subject title is clear.

I need to have only 15 characters in a cell. If the characters in a cell are
less than 15.. i need there to be spaces after the characters to make up 15
in total.

Does this make sense ? can it be done ?

Thanks
Mel

Limiting Characters in a cell and adding spaces to fill the re
 

I just figured it out !! thanks !!!!!

"Melissa" wrote:

Thanks for the quick reply.

How do i check that it has worked. It is showing the result in a new cell
but how do i turn it from a formula to just characters



"Ag" wrote:

Assuming that column A contains all the information you can create
column B as per your mail by using the following fomula in cell B1 and
copying it subsequent rows
=IF(LEN(A1)<15,A1&REPT(" ",15-LEN(A1)),LEFT(A1,15))


On Jan 11, 5:57 am, Melissa wrote:
Sorry not sure if subject title is clear.

I need to have only 15 characters in a cell. If the characters in a cell are
less than 15.. i need there to be spaces after the characters to make up 15
in total.

Does this make sense ? can it be done ?

Thanks
Mel

Limiting Characters in a cell and adding spaces to fill the re
 

Thank you so much !! worked perfectly ! saved me hours (days) of work .. (
19000 x 3 cells)


"Dave Peterson" wrote:

Can you use a formula in another cell?

=left(a1&rept(" ",15),15)

This will truncate the value in A1 if the length is greater than 15, too.


Melissa wrote:

Sorry not sure if subject title is clear.

I need to have only 15 characters in a cell. If the characters in a cell are
less than 15.. i need there to be spaces after the characters to make up 15
in total.

Does this make sense ? can it be done ?

Thanks
Mel

--

Dave Peterson