1

I have a field with hex a decimal values that look like FF FE, I need to remove the white space so the results are FFFE but trim is not working for me! Is there another function I can use?

justZito
  • 569
  • 1
  • 10
  • 19
  • 4
    `TRIM` removes only leading and trailing spaces. `Is there another function I can use` - yes, `=SUBSTITUTE(A1," ","")` – Dmitry Pavliv Mar 01 '14 at 14:07
  • Possible Duplicate : http://stackoverflow.com/questions/9190764/excel-formula-to-remove-space-between-words-in-a-cell – cvraman Mar 01 '14 at 14:10
  • See http://stackoverflow.com/questions/9578397/how-to-remove-leading-or-trailing-spaces-in-an-entire-column-of-excel-worksheet/9582919#9582919. Often the issue is CHAR(160) – brettdj Mar 02 '14 at 03:34

1 Answers1

2

Trim only removes whitespace at the beginning and end. Use substitute instead.

=SUBSTITUTE({cell ref}," ","")

should do the trick

Stewart_R
  • 13,764
  • 11
  • 60
  • 106