| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove space
i need code to remove space from text
for example: A1 = " Brenda" How do i remove the space infront of Brenda from cell A1? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
remove space
Either in code or as a worksheet you can use the Trim function...
-- HTH... Jim Thomlinson "ernie" wrote: i need code to remove space from text for example: A1 = " Brenda" How do i remove the space infront of Brenda from cell A1? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
remove space
oh yeah now i remember
thank you sir "Jim Thomlinson" wrote: Either in code or as a worksheet you can use the Trim function... -- HTH... Jim Thomlinson "ernie" wrote: i need code to remove space from text for example: A1 = " Brenda" How do i remove the space infront of Brenda from cell A1? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove non-space spaces? | Excel Worksheet Functions | |||
| remove space | Excel Worksheet Functions | |||
| How to remove a space | Excel Discussion (Misc queries) | |||
| Remove Space in Text | Excel Discussion (Misc queries) | |||
| macro to remove space | Excel Programming | |||
Linear Mode
