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

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



" wrote:

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

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
---