?
Solved

How do you handle proper case when your data contains mm (millimeters)

Posted on 2014-04-15
1
Medium Priority
?
189 Views
Last Modified: 2014-04-20
Hi

I have some data all in capitals but i want to change it to proper case which i did. Some data contained mms and went from this

WHITE CUNINA RADIATOR 1500 x 405mm      
to
White Cunina Radiator 1500 X 405Mm

Naturally i want White Cunina Radiator 1500 X 405mm

Thanks in advance for any help you can give
0
Comment
Question by:andieje
1 Comment
 
LVL 1

Accepted Solution

by:
ProTechComputing earned 2000 total points
ID: 40001601
I'd go ahead and make the change as you showed above, then run find/replace for Mm to mm.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question