Excel Magic Trick 1014: Text To Columns to Split Data From A Cell and Avoid Extra Spaces

preview_player
Показать описание

See how to use Text To Columns to Split Data From A Cell and Avoid Extra Spaces
1. Use delimiters space and dash in the Text To Columns dialog box to avoid extra spaces in cells.
Рекомендации по теме
Комментарии
Автор

I am glad that you like it! I just figured this out my self and it saves a lot of hassle!

excelisfun
Автор

Nice. I use this all the time at work. Thanks for the added trick of the space issue.

RedClayBulldogsTV
Автор

Yes, most large data sets are not neat and clean...

excelisfun
Автор

I use this feature quite often too. thanks for the extra tips though. didn't know that before this. thank you.

elphau
Автор

You are a giant among insects. Thank you

simonpine
Автор

how can i do a text to column on a seperate sheet?

Chevylifter