Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing blank characters ?
::Hi, I have a column that contains a reference number. Some of the records have blank spaces in them or immediately after them, e.g. (assume \\" is a blank space) 1234\\"\\"\\" 12\\"3456 Is there an easy way to select the column, remove all blank spaces and to then left-align the result ? Thanks in advance for your continued help. Matt:: -- bvinternet ------------------------------------------------------------------------ bvinternet's Profile: http://www.excelforum.com/member.php...o&userid=25525 View this thread: http://www.excelforum.com/showthread...hreadid=389678 |
#2
|
|||
|
|||
Select the column (assuming this is column A, click the A to highlight the whole column), click EDIT, Replace, put a space in the 'find what', and then click 'Replace All' -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=389678 |
#3
|
|||
|
|||
Hi,
select the column go to menu EditReplace in Find what' box type a space leave 'Replace with' box empty press 'Replace All' button Regards, KL "bvinternet" wrote in message ... ::Hi, I have a column that contains a reference number. Some of the records have blank spaces in them or immediately after them, e.g. (assume \\" is a blank space) 1234\\"\\"\\" 12\\"3456 Is there an easy way to select the column, remove all blank spaces and to then left-align the result ? Thanks in advance for your continued help. Matt:: -- bvinternet ------------------------------------------------------------------------ bvinternet's Profile: http://www.excelforum.com/member.php...o&userid=25525 View this thread: http://www.excelforum.com/showthread...hreadid=389678 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing the word (blank) from pivot table cells | Excel Discussion (Misc queries) | |||
Deleting Blank Characters in a Cell | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
removing some of the characters from a cell | Excel Discussion (Misc queries) | |||
Removing unused or blank rows and columns | Excel Discussion (Misc queries) |