Trim function limitations

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
 
A

Andy Brown

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

Rgds,
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
Function =Trim() 5
Remove non-space spaces? 3
Trim and Substitute not working 4
TRIM Q 3
TRIM FUNCTION...how to? 3
Vlookup to reference offset 1
Function to evaluate function as string 3

Top