Cell with same number of characters

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).
 
C

Claus Busch

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.
 

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

Square character(s) in cells 2
Eliminating cells with non-matching characters 1
Hide non-printing characters. 5
Autocopy the first cell with more than 30 characters to a different sheet? 1
Count Dates? 5
how do i delete using COUNTIF for specific values? 2
Conditional formatting 1
I want to sort, ignoring all characters except numbers 15

Top