Excel Help and Problems

[AnonymousUser]

Whats an easy way to remove every second row of data?

Write a macro? And start from the bottom up.

[MarkS]

Whats an easy way to remove every second row of data?

One way you can do it is:
In the column to the right of all the data, enter a 1 on the first row, 0 on 2nd row, drag it down to the bottom and select copy cells. Now, every other row will have a 1 at the end and every other row will have a 0.

Filter to show only the 1's and not the zeros.  Copy/paste the filtered data to a new tab and you'll have just the data you want.

[myb821]

Whats an easy way to remove every second row of data?

add a new column at the end of all your data. in the first row put a 1 and in the second row put a 2 drag down those two rows to the end of your data. Filter to only see the "2" rows. Then delete

[myb821]

One way you can do it is:
In the column to the right of all the data, enter a 1 on the first row, 0 on 2nd row, drag it down to the bottom and select copy cells. Now, every other row will have a 1 at the end and every other row will have a 0.

Filter to show only the 1's and not the zeros.  Copy/paste the filtered data to a new tab and you'll have just the data you want.

add a new column at the end of all your data. in the first row put a 1 and in the second row put a 2 drag down those two rows to the end of your data. Filter to only see the "2" rows. Then delete

you beat me to it

[churnbabychurn]

Was thinking something similar...
Thanks!

[churnbabychurn]

add a new column at the end of all your data. in the first row put a 1 and in the second row put a 2 drag down those two rows to the end of your data. Filter to only see the "2" rows. Then delete

How do I delete the "2" rows?

[MarkS]

How do I delete the "2" rows?

Once they're filtered out, copy paste the data to another tab.

[churnbabychurn]

did "go to select", visible only and then deleted...

[churnbabychurn]

Once they're filtered out, copy paste the data to another tab.

That works also. another tab is key...

[etech0]

Or you can then sort by column a, and delete the whole lot of them.

[unavailable]

Is there a way to make the first letter of every word capital. I have a list of names (first and last) some are fully lower case done fully upper case, is there an option to get them all first letter capital and the rest lower case
TIA

[MarkS]

Is there a way to make the first letter of every word capital. I have a list of names (first and last) some are fully lower case done fully upper case, is there an option to get them all first letter capital and the rest lower case
TIA

Use the function =proper()
If Column A has the text, in B1 type  =proper(A1) and drag that down

[unavailable]

Use the function =proper()
If Column A has the text, in B1 type  =proper(A1) and drag that down

Thanks I'm not by a computer so I'll try later
Thanks again

[smurf]

Is there a way to make the first letter of every word capital. I have a list of names (first and last) some are fully lower case done fully upper case, is there an option to get them all first letter capital and the rest lower case
TIA

Use this Macro to trim (remove extra spaces) And make proper

Code: [Select]

Sub proper_trim()

Dim CleanTrimRg As Range
Dim oCell As Range
Dim Func As WorksheetFunction

Set Func = Application.WorksheetFunction

On Error Resume Next
Set CleanTrimRg = Selection.SpecialCells(xlCellTypeConstants, xlTextValues)
If Err Then MsgBox "No data to clean and Trim!": Exit Sub

For Each oCell In CleanTrimRg
    oCell = Func.Proper(Func.Trim(oCell))
Next

End Sub
Then select the cells you want and run the macro.
You can easily adapt the code to only make proper or only trim if you like.
I know this can be done with a formula as others have mentioned but this way you dont have to add and remove columns

[unavailable]

Thanks Smurf but it sounds to me like Chinese

[EJB]

Thanks Smurf but it sounds to me like Chinese

Here's a way without using VBA.

Assuming your first name is in cell A1, use the following code:
=UPPER(LEFT((A1),1))&LOWER(MID(A1,2,LEN(A1)-1))

If you want to add last name as well, you can quickly adjust the formula to do so.

[unavailable]

Thanks Ejb this way does seem a bit easier but wouldn't be sure I got it until I tried it when I'll be on computer

[smurf]

Here's a way without using VBA.

Assuming your first name is in cell A1, use the following code:
=UPPER(LEFT((A1),1))&LOWER(MID(A1,2,LEN(A1)-1))

If you want to add last name as well, you can quickly adjust the formula to do so.

Once going with a formula why not just use =Proper()?

[unavailable]

Do I have to do the formula in column b. Why can't I set this formula in a? (Sounds like a question of an illiterate,I know)

[lubaby]

Once going with a formula why not just use =Proper()?

Maybe it's too simple