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
|