Excel formula to remove space between words in a cell

0 votes
I've a huge data in excel file.

For eg: say i've a word like paul son,i've to make it as paulson.

input:paul son output:paulson.

In some cells ,i've data like mic-li,when this type of words come,it should not replace any thing,it should only remove spaces in between words.
Mar 28, 2022 in Database by Edureka
• 13,690 points
741 views

1 answer to this question.

0 votes
There are three fast techniques to get rid of unnecessary spaces between words or remove all spaces from Excel cells. To clean up the content of cells, you can use the trim formula, Excel Find & Replace, or a special Excel add-in.

When you paste data from an external source (plain text reports, numbers from web sites, etc.) into an Excel spreadsheet, you're likely to acquire additional spaces in addition to vital data. Leading and trailing spaces, multiple blanks between sentences, and thousand separators for numbers are all possible.

As a result, your table appears disorganised and is difficult to utilise. It may be difficult to locate a client in the Name column since you are looking for "John Doe," which has no extra spaces between the names, yet your table reads "John Doe." Alternatively, if numbers can't be added up, extra blanks are to fault.
answered Mar 30, 2022 by gaurav
• 23,260 points

Related Questions In Database

0 votes
1 answer

Excel formula to remove comma, spaces, period and add a text

The steps to accomplish this are as ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
2,236 views
0 votes
1 answer

What is the Excel formula to countif text partially makes up a cell?

With Formulas, Countif Partial String/Substring Match We can ...READ MORE

answered Mar 30, 2022 in Database by gaurav
• 23,260 points
15,254 views
0 votes
1 answer
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
783 views
0 votes
1 answer

[Excel][VBA] How to draw a line in a graph?

Sub MakeChart() Dim x(20) ...READ MORE

answered Mar 24, 2022 in Database by gaurav
• 23,260 points
1,965 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Convert numbers to words in Excel (VBA)

In the cell where you wish to ...READ MORE

answered Mar 25, 2022 in Database by gaurav
• 23,260 points
28,651 views
0 votes
1 answer

Insert a value to a cell in excel using formula in another cell

Select the cell where the formula should ...READ MORE

answered Mar 25, 2022 in Database by gaurav
• 23,260 points
4,799 views
0 votes
1 answer

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
10,024 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP