My boss wants to remove the space between two words in a single cell with a formula so he can apply the formula to the whole column instead of having to go through and delete the space manually down the column.

Is there a formula to do such a thing? No one here seems to know. I only know the basics and I'm thinking that it's not possible but I could so easily be wrong.

Thanks!

I'm guessing that I'm right about it not being possible. I told him just to change the first one and then copy it down.

It is possible. My father has done some crazy things with Excel. (like created tables based on the file structure of a folder, and contents within) Sadly, I don't know anything about Excel to help you.

It's possible, though not as easy as it should be since Excel lacks a WORD() function for no reason I can determine. If the value is in cell A1 and is two words precisely, try this: =CONCAT(LEFT(A1,POS(A1," ")-1),RIGHT(A1,LEN(A1)-POS(A1," ")))

Hey cool! Thanks! I passed it along to tha bossman.

Hmm, I thought I had fixed that, but I guess my edit never happened. What I gave you isn't Excel syntax exactly, this is what you want:

=CONCATENATE(LEFT(A1,FIND(" ",A1)-1),RIGHT(A1,LEN(A1)-FIND(" ",A1)))

Sorry. I was sure I had fixed that an hour ago.

Edit: I know what happened, I did two edits, and the stupid forum doesn't have its refresh tag right, so the second one pulled up the original, not the edited, text, so it changed it right back.