View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Trim Leading Spaces

Using trim leaves a space between the quotes and the first and last letter so
a bit more complicated but try

=CONCATENATE("""",TRIM(MID(A15,2,LEN(A15)-2)),"""")

where your string is in A15

"Steven" wrote:

How do I trim the just the leading and trailing spaces in a cell?
For example

" Project - 1234 " becomes "Project - 1234"

Thank you for you help.

Steven