| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I delete spaces that follows data
I have an Excel spreadsheet containing numerous columns/rows of data. I want
to remove any spaces that follow the data. For example in column A2 the word Marianne is followed with spaces. Each row varies in the length of text and the spaces that follow. I tried using =CLEAN(Sheet1!A2) but that didn't work when I pasted special value back into the field. Please help! Thank you. Susan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete spaces that follows data
Try the trim function:
=Trim(Sheet1!A2) -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "ILoveMyCorgi" wrote: I have an Excel spreadsheet containing numerous columns/rows of data. I want to remove any spaces that follow the data. For example in column A2 the word Marianne is followed with spaces. Each row varies in the length of text and the spaces that follow. I tried using =CLEAN(Sheet1!A2) but that didn't work when I pasted special value back into the field. Please help! Thank you. Susan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete spaces that follows data
Thank you! You've made my weekend. Have a good one yourself. Susan
"Michael Arch" wrote: Try the trim function: =Trim(Sheet1!A2) -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "ILoveMyCorgi" wrote: I have an Excel spreadsheet containing numerous columns/rows of data. I want to remove any spaces that follow the data. For example in column A2 the word Marianne is followed with spaces. Each row varies in the length of text and the spaces that follow. I tried using =CLEAN(Sheet1!A2) but that didn't work when I pasted special value back into the field. Please help! Thank you. Susan |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete spaces that follows data
You could try:
Select the column Data|text to columns (in xl2003 menus) Fixed width Remove any lines that excel guessed and don't add any of your own. and plop the results in the original range. ILoveMyCorgi wrote: I have an Excel spreadsheet containing numerous columns/rows of data. I want to remove any spaces that follow the data. For example in column A2 the word Marianne is followed with spaces. Each row varies in the length of text and the spaces that follow. I tried using =CLEAN(Sheet1!A2) but that didn't work when I pasted special value back into the field. Please help! Thank you. Susan -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete spaces | Excel Discussion (Misc queries) | |||
| delete spaces | Excel Programming | |||
| how do I delete the last two spaces in a cell | Excel Discussion (Misc queries) | |||
| DELETE SPACES In part | Excel Programming | |||
| delete spaces | Excel Worksheet Functions | |||
Linear Mode
