REPT function excel

[user29383902]

Hi,

Please I need excel to repeat text in a cell 2x
That is REPT(text, 2)
IF the text is not repeated, but if it is already repeated 2x, it should not and leave it that way.

=IF(B2=REPT(B2,1), B2=REPT(B2,2), B2=B2)

It gives me False, then 0 gives me true.

Excel formula or VBA would be greatly appreciated.

 

[Cubist]

Try:

=IF(B2=REPT(B2,2), B2, REPT(B2,2))

 

[Rick Rothstein]

Try:

=IF(B2=REPT(B2,2), B2, REPT(B2,2))

That formula will always return the contents of B2 doubled, but I think writing it this way should work...

=IF(B2=REPT(LEFT(B2,LEN(B2)/2),2), B2, REPT(B2,2))

 

[Phuoc]

Or try this:

=IF(REPT(LEFT(B2,LEN(B2)/2),2)=B2,B2,B2&B2)

 

[Scott Huish]

Without the IF and a little shorter:
=REPT(B2,1+(LEFT(B2,LEN(B2)/2)<>B2))

 

[Peter_SSs]

Without the IF and a little shorter:
=REPT(B2,1+(LEFT(B2,LEN(B2)/2)<>B2))

That doesn't work for me. It always repeats B2 (unless B2 is empty)

Speaking of empty, if there could be empty cells, this variation would return a null string instead of a zero like a couple of the options above.

=REPT(B2,1+(B2<>REPT(LEFT(B2,LEN(B2)/2),2)))

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

REPT function in Excel

Please I need excel to repeat text in a cell 2x That is REPT(text, 2) IF the text is not repeated, but if it is already repeated 2x, it should not and leave it that way. I tried using this formular...

stackoverflow.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.