Removing Tab Spaces

Apologies if this been answered before, but I'm having issues removing multiple tab spaces from cells. Tried using Find & Replace with alt + 0009, as well as ^t, but this does not appear to be searchable criteria in the current version of Excel. Any recommendations would be greatly appreciated.

Thank you

Hello and welcome to the forum.

I recommend uploading a small representative sample of your data that shows the spaces that you are talking about.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

Thanks, appreciate the tip. Attached are a couple of cells, and I'd like to remove the excess tabs to left align the text.

Select the range then Ctrl + H (Replace dialog box)

Enter Alt + 0010 in What and a space in Replace.

Note: 0010 MUST be entered from a number pad, not the numbers on the top of the keyboard.

Thanks All, I appreciate the quick responses. These options worked for removing line-breaking spaces, but didn't appear to delete the tabbed spaces.

Tab is CHAR(9).

Here's one option to get rid of them:

B1 =SUBSTITUTE(A1,CHAR(9),"")

Thank you both - Falcondude, this is exactly what I needed. Very much appreciated.

You’re welcome, happy to help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.