Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've been using Trim to delete extra spaces from fields that contain imported
data. Today I tried to use it on data that I'd copied from a webpage and inserted into a spreadsheet, but it wouldn't take off the blanks after the numbers. Am I mis-using the function? These were numbers that I'd copied as a bulk which 'self-segregated' into individual cells. I then re-copied them changing from colums to rows using Paste-Special. Then I tried to use Trim, but it had no effect. I needed to remove the spaces so that I could divide the numbers by 100. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function =Trim() | Excel Worksheet Functions | |||
Trim Function | Excel Discussion (Misc queries) | |||
TRIM function | New Users to Excel | |||
Trim Function | Excel Worksheet Functions | |||
Trim function | Excel Worksheet Functions |