text problem

  • Thread starter Thread starter Bre-x
  • Start date Start date
B

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
 
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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
I did help!!
thank you

Anne Troy said:
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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Click to expand...
 
Back
Top