Custom formatting

[Yvonne]

I have a very large spreadsheet in which I need to change all dates that
appear this way: 1994 - 1995, to this: (1994 - 1995).

Is there any way I can create a custom format for the latter? Otherwise I
have to go through each cell one by one and change each one individually.

I hope someone can help...

 

[Gary''s Student]

If the data is in a column, then use a helper column. Say the data is in
column A. In B1 enter:

="(" & A1 & ")" and copy down.


If you dates are scattered, then a macro is the best approach.

 

[Ivyleaf]

If the data is in a column, then use a helper column.  Say the data is in
column A.  In B1 enter:

="(" & A1 & ")" and copy down.

If you dates are scattered, then a macro is the best approach.
--
Gary''s Student - gsnu200777







- Show quoted text -

Or as a custom format: (@)

Cheers,
Ivan.

 

[Yvonne]

Thanks, it is helpful, but I am relatively new to Excel, and I'm not familiar
with macros.

The dates are scattered. I need this:

National Yeast 1950-1951,1955-1957; General Motors 1954-1955; Parker Sheet
Metal 1956-1960; Sun Oil Co., 1965-1986

to look like this:

National Yeast (1950-1951,1955-1957); General Motors (1954-1955); Parker
Sheet Metal (1956-1960); Sun Oil Co., (1965-1986)

We have a database at work that runs reports, and puts all information into
an Excel document. If the information isn't entered correctly into our
database in the first place, then we are left to clean up the mess in the
reports. It wastes a great deal of time, and I was hoping there might be a
way to cut back on that time.

Is there a macro for me somewhere out there?

 

[Ivyleaf]

Thanks, it is helpful, but I am relatively new to Excel, and I'm not familiar
with macros.  

The dates are scattered.  I need this:

National Yeast 1950-1951,1955-1957; General Motors 1954-1955; Parker Sheet
Metal 1956-1960; Sun Oil Co., 1965-1986

to look like this:

National Yeast (1950-1951,1955-1957); General Motors (1954-1955); Parker
Sheet Metal (1956-1960); Sun Oil Co., (1965-1986)

We have a database at work that runs reports, and puts all information into
an Excel document.  If the information isn't entered correctly into our
database in the first place, then we are left to clean up the mess in the
reports.  It wastes a great deal of time, and I was hoping there might be a
way to cut back on that time.

Is there a macro for me somewhere out there?  








- Show quoted text -

Hi Yvonne,

Where you write the example, do the semicolons represent different
cells? i.e. is the data as such:

cell A1: "National Yeast 1950-1951"
cell A2: "General Motors 1954-1955"
cell A3: "Parker Sheet Metal 1956-1960"
cell A4: "Sun Oil Co., 1965-1986"
etc...

or do they run across in a row, or is the whole thing just one big
string in a cell? Shouldn't be hard to write a macro for it, but the
more info we have on the structure of your data te easier it will be.

Cheers,
Ivan.