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 in Database by Edureka
• 13,640 points
38 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 by gaurav
• 13,560 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 in Database by gaurav
• 13,560 points
105 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 in Database by gaurav
• 13,560 points
37 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 in Database by gaurav
• 13,560 points
44 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 in Database by gaurav
• 13,560 points
78 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 in Database by gaurav
• 13,560 points
86 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 in Database by gaurav
• 13,560 points
77 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 in Database by gaurav
• 13,560 points
41 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP