remove or adding spacing

D

dedibondan

dear all,

i'v problem i cant remove or adding space one by one text in excel, my
question how to add or remove spacing?
Thx a lot before
 
S

Sheeloo

Not clear what you really want to do...

Space can be represented by " ".
If A1 contains A and B1 contains B then
=A1&" "&B1 will give you A B in C1
 
M

Max

Post some samples of the data that you have (is it all in one cell?, etc),
and explain exactly what you seek to achieve (describe the expected results)

Some general thoughts:
To remove extraneous spacings - Try TRIM
To split data in one col into separate cols - Try Data > Text to Columns
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
 
Top