remove - from field
 

i have a general field 100-11-11-00

i want to remove the - and make it 100111100

remove - from field
 

One way:

Select the data to change. Choose Edit/Replace...

Find what: -
Replace with: <blank

Click Replace All

if you want to use a formula:

=SUBSTITUTE(A1,"-","")



In article ,
dlb1228 wrote:

i have a general field 100-11-11-00

i want to remove the - and make it 100111100

remove - from field
 

Hi,

just select the cells where you want to do the reemoval, then from menu
Edit, Substitute in the Find field digit - and leave blank the field
Substitue with.

Then click on Substitute All.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy



"dlb1228" ha scritto nel messaggio
...
i have a general field 100-11-11-00

i want to remove the - and make it 100111100