text problem

[Bre-x]

Hi,
I have a text column with values like: 6357- 1
how can i convert it to 6357-1
no spaces between the " - " and 1

Thank you all,

Bre-x

 

[Anne Troy]

Select the column in table view. Hit Ctrl+H. Put a space in FIND and don't
put anything in the replace with box. Hit replace all. Of course, make sure
you want to delete all spaces in that column of data first.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[Bre-x]

I did help!!
thank you

Select the column in table view. Hit Ctrl+H. Put a space in FIND and don't
put anything in the replace with box. Hit replace all. Of course, make sure
you want to delete all spaces in that column of data first.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->