Cell with same number of characters

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

The source cells contain 12 to 26 characters.

What formula do I use so the target cells contain 30 characters?

(Do NOT give me a macro).
 
Hi Gary,

Am Thu, 20 Nov 2014 10:09:51 -0800 (PST) schrieb gary:
The source cells contain 12 to 26 characters.

What formula do I use so the target cells contain 30 characters?
Click to expand...

your source cell is A1 then:
=A1&REPT("_",30-LEN(A1))
Replace the underline with your expected char.


Regards
Claus B.
 
Back
Top