Increase number of characters in a cell

How can I inrease the number of characters in a cell by adding blanks. The cell contains alphbetic and numeric characters. I have different variations some with 7 or 8 or 9 characters and I need to have all with 10 characters.



Example

PBK 792 need to be PBK 792
PDW 006 need to be PDW 006
PGF 003 need to be PGF 003

It's not so obvious on the display, but I think you want to put the spaces between the alpha and the numeric part. If so you can use this:

=SUBSTITUTE(TRIM(A1)," ",REPT(" ",11-LEN(TRIM(A1))))

and copy down.

Hope this helps.

Pete

---------- Post added at 02:09 PM ---------- Previous post was at 02:07 PM ----------

Originally Posted by bonny24tycoon

I dont see the difference as PBK 792 need to be PBK 792, look alike?

Bonny,

click on Reply with Quote after the first post, and you can see the extra spaces between the alpha and the numeric part in the quoted section.

Hope this helps.

Pete

Thank You Pete