| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting blank spaces in cells
Hi all I have spreadsheet (converted from report) which contains cells that contain data and blank spaces. I want to keep the data and delete the blank spaces. All cells are not formatted the same eg some are 4 blank spaces and then text, some are text and 14 blank spaces. Please help! -- Mr Gow ------------------------------------------------------------------------ Mr Gow's Profile: http://www.excelforum.com/member.php...o&userid=34511 View this thread: http://www.excelforum.com/showthread...hreadid=542758 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting blank spaces in cells
Hi Mr Gow,
Look at the Trim function in Excel help. Trim will remove the leading and trailing spaces. --- Regards, Norman "Mr Gow" wrote in message ... Hi all I have spreadsheet (converted from report) which contains cells that contain data and blank spaces. I want to keep the data and delete the blank spaces. All cells are not formatted the same eg some are 4 blank spaces and then text, some are text and 14 blank spaces. Please help! -- Mr Gow ------------------------------------------------------------------------ Mr Gow's Profile: http://www.excelforum.com/member.php...o&userid=34511 View this thread: http://www.excelforum.com/showthread...hreadid=542758 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting blank spaces in cells
Hi Mr Gow,
Depending on the nature of the spaces, you may also wish to visit David McRitchie's TrimAll page at: http://www.mvps.org/dmcritchie/excel/join.htm#trimall --- Regards, Norman |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting blank spaces in cells
You can set up a helper column and use the TRIM function to remove extra
spaces. =TRIM(B1) Then copy this formula as far as necessary, copy, click Edit/PasteSpecial - values. Then delete the original data. Play with it a little bit, just be sure to back up your data. "Mr Gow" wrote: Hi all I have spreadsheet (converted from report) which contains cells that contain data and blank spaces. I want to keep the data and delete the blank spaces. All cells are not formatted the same eg some are 4 blank spaces and then text, some are text and 14 blank spaces. Please help! -- Mr Gow ------------------------------------------------------------------------ Mr Gow's Profile: http://www.excelforum.com/member.php...o&userid=34511 View this thread: http://www.excelforum.com/showthread...hreadid=542758 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting blank spaces in cells
If you want to get rid of all the spaces--including any between words:
Select the range to fix edit|replace what: (spacebar) with: (leave blank) replace all Mr Gow wrote: would become MrGowwrote: Mr Gow wrote: Hi all I have spreadsheet (converted from report) which contains cells that contain data and blank spaces. I want to keep the data and delete the blank spaces. All cells are not formatted the same eg some are 4 blank spaces and then text, some are text and 14 blank spaces. Please help! -- Mr Gow ------------------------------------------------------------------------ Mr Gow's Profile: http://www.excelforum.com/member.php...o&userid=34511 View this thread: http://www.excelforum.com/showthread...hreadid=542758 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Blank Cells Wholesale? | Excel Discussion (Misc queries) | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
| Blank cells represented in area charts | Charts and Charting in Excel | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
