remove spacing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tiffany - 17 Aug 2007 02:06 GMT

Hi,

i hv a column that contains all the model name. I want to remove the spacing
in the model name. e.g. from abc 123 to abc123. May i know how to do it.

Thank you

Reply to this Message

Max - 17 Aug 2007 02:20 GMT

Select the col range
Click Edit>Replace
Type a space in the "Find what:" box
Leave "Replace with:" empty
Click Replace All

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi,
>
> i hv a column that contains all the model name. I want to remove the spacing
> in the model name. e.g. from abc 123 to abc123. May i know how to do it.
>
> Thank you

Reply to this Message

Dave Peterson - 17 Aug 2007 02:21 GMT

Select the range to fix
Edit|Replace
what: (spacebar)
with: (leave empty)
replace all

> Hi,
>
> i hv a column that contains all the model name. I want to remove the spacing
> in the model name. e.g. from abc 123 to abc123. May i know how to do it.
>
> Thank you

Signature

Dave Peterson

Reply to this Message

Rate this thread: