CODEWITHSUNDEEP
excelvba
siwmas
siwmas

Reputation: 389

Align cells by separator

I need to align cells by ":"

For example

 54,585,889 : 2.0%
  4,585,887 :   
    585,889 : 32.0%

Any ideas?

Upvotes: 0

Views: 136

Answers (1)

Alexander Frolov
Alexander Frolov

Reputation: 306

Please create the helper column with the following formula

=REPT(" ",15-FIND(":",A1))&A1

where A1 - your original string and 15 - the maximal number of characters before ":" in your data

Then apply the monotype font (e.g. "Courier new") to this column.

Upvotes: 2

Related Questions