Splitting text cells without a common denominator

W

Wackyracer

I have a list that contains various names that I need to simplify. e.g. "Best
Business Company Limited" shortens to Best Business. However, I also have
names that start "A B Best Business" (shorten to A B Best), or "Best A B
Business" (Best A B).

Does anyone have any suggestions please.
 
F

Frank Kabel

Hi
don't think this is possible as you don't have a rule which could be
implemented in a program. What is the logic why you want to skip
'Buisness' in the second example?

If you have a list of all words which could e omitted then this is
possible. e.g. delete all words such as
Company
Business
Limited
Ltd
Co
....
 
W

Wackyracer

Sorry, perhaps I did not explain the problem very well. I just need to
shorten the entries so they do not take up so much room. (I have a large
report that I need to print each week and I am just trying to buy myself some
extra room. I have to shrink the page in page setup to fit all the
information).

Your suggestion for omitting certain words would be perfect. How do I go
about this please?
 
W

Wackyracer

Unfortunately I need to be able to automate this process either with a
formula or a macro. I have a raw data file that is then combined with a
template. This is where I need the facility to shorten the names. As this
report is generated several times a week doing this manually is not
practical.

Is there a solution?
 
F

Frank Kabel

Hi
the easiest way would be if you record several Edit - Replace actions
with the macro recorder and use this in the future tu 'clean' your
sheet

--
Regards
Frank Kabel
Frankfurt, Germany

Wackyracer said:
Unfortunately I need to be able to automate this process either with a
formula or a macro. I have a raw data file that is then combined with a
template. This is where I need the facility to shorten the names. As this
report is generated several times a week doing this manually is not
practical.

Is there a solution?
 
Top