Change part of data within a cell.

  • Thread starter Thread starter Materialised
  • Start date Start date
M

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
 
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
Click to expand...

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
 
Back
Top