| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trimming a space in the middle of a string
I have a list of names in one column. I want to trim the space from the
middle so that Jim Jones looks like JimJones. Any help? Thank You |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trimming a space in the middle of a string
Try
=SUBSTITUTE(A1,CHAR(32),) If this post helps click Yes --------------- Jacob Skaria "thomas donino" wrote: I have a list of names in one column. I want to trim the space from the middle so that Jim Jones looks like JimJones. Any help? Thank You |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trimming a space in the middle of a string
VBA solution
Msgbox Replace("Jim Jones",chr(32),"") If this post helps click Yes --------------- Jacob Skaria "thomas donino" wrote: I have a list of names in one column. I want to trim the space from the middle so that Jim Jones looks like JimJones. Any help? Thank You |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trimming a space in the middle of a string
Highlight the column and press Ctrl + H for find & replace - replace " " with
"" (you don't need to type the quotation marks, they're just so you can see what I've typed) "thomas donino" wrote: I have a list of names in one column. I want to trim the space from the middle so that Jim Jones looks like JimJones. Any help? Thank You |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trimming a space in the middle of a string
Since you posted in programming group.
Public Sub Strip_WhiteSpace() Selection.Replace what:=" ", _ replacement:="", lookat:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False End Sub Gord Dibben MS Excel MVP On Wed, 26 Aug 2009 01:13:10 -0700, thomas donino wrote: I have a list of names in one column. I want to trim the space from the middle so that Jim Jones looks like JimJones. Any help? Thank You |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add a character to the middle of a text string | Excel Discussion (Misc queries) | |||
| Forcing a line feed in the middle of a string | Excel Discussion (Misc queries) | |||
| How to extract text from middle of a string | Excel Worksheet Functions | |||
| extract " " space from middle of a string | Excel Worksheet Functions | |||
| How do I remove a space from the middle of a line of numbers? | Excel Discussion (Misc queries) | |||
Linear Mode
