CODEWITHSUNDEEP
excelformat
sam
sam

Reputation: 10064

Remove space after text string in a cell - excel

Ive pasted a large list of data into column A in a excel sheet, all the data has come in with a space after the text ie. 'text ', 'some more text '..

I need to clear away this last space, as an approach i tried to find/replace all spaces, but that left me with a load of text strings like 'somemoretext' as it also deleted all the spaces in between words, any idea how i should handle this ?

Upvotes: 2

Views: 40176

Answers (3)

zx8754
zx8754

Reputation: 56004

TRIM In Microsoft Excel, the TRIM function returns a text value with the leading and trailing spaces removed.

Or you can still use Find and Replace option: Find "text " Replace "text".

Upvotes: 5

Naveed Khan
Naveed Khan

Reputation: 374

You can also remove leading and trailing spaces from column name with this method.

Remove Leading and Trailing Whitespace from Excel Cells

See my answer there.

Upvotes: 0

Maarten
Maarten

Reputation: 11

You can use logical approach: check last character 

(right(cell;1))

=IF(RIGHT(A3;1)=" ";LEFT(A3;LEN(A3)-1);A3)

If an space exists at the end, it will return the string -1 character (the space) if there isn't a space, it will return the text without change

Upvotes: 1

Related Questions