Change part of data within a cell.

[Materialised]

Hello,

I have a long list of data in the format:

a-bb-ccc-yyy-zz

Where all letters are numbers, i.e:

1-01-100-200-00
1-01-100-200-01
1-01-100-230-00
1-01-100-230-01
1-01-100-230-02
1-01-100-230-03
1-01-100-230-04
1-01-100-230-05
1-01-100-230-06
1-01-100-230-07
1-01-100-230-08
1-01-100-230-09
1-01-100-230-10
1-01-100-230-11
1-01-100-230-12
1-01-100-230-13


.... and so on.

The cell fields are all formatted as general. I cant really change this, as
the final output will be save as a .csv and then imported into Sage Line
200.

Basically what I need is a method (macro?) to change the values represented
by a, b, and c, throught the whole worksheet. y and z do not need to be
changed as these represent revenue codes.

So Ideally, the macro, will prompt me to enter new values for a, b, and c,
and then change the values throught the current worksheet.

Does anyone here know a function I could use to achieve this?

Thanks

 

[Ron Rosenfeld]

Hello,

I have a long list of data in the format:

a-bb-ccc-yyy-zz

Where all letters are numbers, i.e:

1-01-100-200-00
1-01-100-200-01
1-01-100-230-00
1-01-100-230-01
1-01-100-230-02
1-01-100-230-03
1-01-100-230-04
1-01-100-230-05
1-01-100-230-06
1-01-100-230-07
1-01-100-230-08
1-01-100-230-09
1-01-100-230-10
1-01-100-230-11
1-01-100-230-12
1-01-100-230-13


... and so on.

The cell fields are all formatted as general. I cant really change this, as
the final output will be save as a .csv and then imported into Sage Line
200.

Basically what I need is a method (macro?) to change the values represented
by a, b, and c, throught the whole worksheet. y and z do not need to be
changed as these represent revenue codes.

So Ideally, the macro, will prompt me to enter new values for a, b, and c,
and then change the values throught the current worksheet.

Does anyone here know a function I could use to achieve this?

Thanks

I would start by looking at the Edit/Replace options and see if that is
suitable for you. If it is, it would probably be simple to record a macro and
then modify it to your precise specifications.


--ron

 

[Bill Ridgeway]

Have you tried <Edit><Replace>?

Regards.

Bill Ridgeway
Computer Solutions