We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

removing spaces from exel file

sam2929
sam2929 asked
on
Medium Priority
321 Views
Last Modified: 2012-05-11
Hi,
I want to remove the space from my exel spread sheet ,i have 10 rows
say row 1 id is in row12345 i want to delete 2345 as it is occuping just row 1
any quick way to do it as i have like 100 rows in there.
i am in 2003

Thanks
Comment
Watch Question

You can use this freeware to remove sapces from Excel documents. I haved used it and it works great!

http://www.ablebits.com/excel-trim-spaces/index.php
CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
How can i convert them to lower cases there are like 50 records

Input

Transmit Date (UTC)
Event COD

Output

transmit_date_utc
event_cod

Thanks
CERTIFIED EXPERT
Top Expert 2008

Commented:
Excel does not have functionality to change the case of text strings. It does have a function you can use:

   =LOWER(A1)

This will put the lower case version of the text in A1 into the cell containing the above formula.

Kevin
Most Valuable Expert 2012
Top Expert 2012

Commented:
@sam2929

Put this in a VBA Project Explorer (ALT-F11) code module (Insert module) and run the macro ConvertAllLowerCase() to do deal with case conversion for whatever the active worksheet is:
Option Explicit
Sub ConvertAllLowerCase()
Dim myString As Range

    For Each myString In ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants, xlTextValues) 'find all text string values
        myString.Value = LCase(myString.Value)
    Next myString

End Sub

Open in new window

See attached for example.

Enjoy!

Dave
SheetToLowerCase-r1.xlsm
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.