Trim function limitations

  • Thread starter Thread starter Boz.theale
  • Start date Start date
B

Boz.theale

I have imported text from another application and want to convert the
contents of cells into a continuous string - ie like trim but removing
all spaces, including those between words.

Eg I want a formula that will convert ABC 123 into ABC123.

Can anyone suggest a solution?

Thanks in advance
 
You could try selecting your range, then CTRL+H (Replace).
Find What = " " (spacebar), leave "Replace With" blank. Click Replace All.

Rgds,
Andy
 
Back
Top