How can i specify a cell to have a fixed number of characters

G

Guest

I need to concatenate text from 4 cells so that in the final string the text
from each cell is padded up to a length of 40 characters.
any ideas?
 
D

Dave Peterson

=left(a1&rept(" ",40),40)&left(b1&rept(" ",40),40) & .....

If you have numbers/dates, you may want:

=right(rept(" ",40)&text(a1,"mm/dd/yyyy"),40) & .....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut the last 20 characters out of a text string 4
How can I count the number of characters on a cell? 11
Excel 2003 - Maximum number of characters a cell can contain? 1
Can you exceed 15 number characters in an excel cell? 1
Formula to validate characters within a string of data in aparticular cell 1
Fixed length string of text 7
I need to have a certain number of characters in a cell 8
one cell to many 2

Top