I have a formula in R2 that needs to equal 25 total characters with white spaces at the end.
formula so far is. =K2&L2&" "&E2&"BL"&D2.
How can I require the remaining?
I have a formula in R2 that needs to equal 25 total characters with white spaces at the end.
formula so far is. =K2&L2&" "&E2&"BL"&D2.
How can I require the remaining?
Someone else may have a more compact way of doing this. Try:
Does that give you what you're looking for?Please Login or Register to view this content.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
Excellent
That did the trick
Thank you
You're welcome, happy to help.
the shorter version would be
Please Login or Register to view this content.
Last edited by Roel Jongman; 05-13-2019 at 04:51 PM.
One more question please how would i remove all white space in all columns but add the remaining to R2 to total 25?
I think it is already doing it with the Len correct?
=IF(LEN(K2&L2&" "&E2&"BL"&C2)<25,K2&L2&" "&E2&"BL"&C2 & REPT(" ",25-LEN(K2&L2&" "&E2&"BL"&C2)),K2&L2&" "&E2&"BL"&C2)
Last edited by booney440; 05-13-2019 at 06:10 PM.
Another version:
=LEFT(K2&L2&" "&E2&"BL"&D2 & REPT(" ", 25), 25)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks