Standarized Spacing

[gmduece]

Hello,



I have several hundred rows of docs(all single line.) All begin with a letter followed by three numbers, then all have a description



Example:



A021 Transfer to remaining Tenant



Is there an expression or formula I can use to make the spacing between the title(A021) and Description(Transfer) the same in all entries



Thank You

 

[Noodleski]

again... stupid me. Need coffee.

 

[Rick Rothstein]

This formula will collapse all multiple consecutive space, up to a total of 120 of them, down to single spaces...
[table="width: 500"]
[tr]
[td]

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"             "," "),"     "," "),"   "," "),"   "," "),"  "," ")

[/td]
[/tr]
[/table]

The number of consecutive space in those runs of multiple spaces are 13, 5, 3, 3 and 2. If you do not ever expect more than 12 consecutive space, you can eliminate one of the SUBSTIUTE function calls...
[table="width: 500"]
[tr]
[td]

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"     "," "),"   "," "),"   "," "),"  "," ")

[/td]
[/tr]
[/table]

 

[gmduece]

I may have described the situation badly. I concatenated two columns, the first containing 4 characters, always one letter first followed always by three numbers...no space. Column two are descriptions of varying lengths. The results of joining the two put all kinds of spacing between the 4 characters and the description is all over the place, from zero to 5 spaces. I want to make all a separation of three spaces

From A021Termination TO A021 Termination

From A021 Termination TO A021 Termination

Thanks

 

[gmduece]

Posting totally took away my formatting. Second example should begin with 5 spaces between Label and Description

Sorry