How to remove white spaces in google docs spreadsheet cells?

Question

I am taking input in the form of a string in a google spreadsheet (through forms). I need to make sure that there are no white spaces before and after this string...

I've tried using Javascript command

mystring = mystring.replace(/(^\s+|\s+$)/g,' ');

but it doesnt seem to work here.

Please help

btw: a simple search will give you this.. http://stackoverflow.com/a/6163202/568414 — Ofir Hadad, Jan 24 '13 at 21:41

score 1 · Answer 1 · answered Jul 11 '14 at 13:05

1

If your string is inside a google docs sheet, can you just apply the TRIM() function to it before importing to your application? TRIM() does exactly what you are looking for, plus removes duplicated intermediate spaces that trouble formatting.

answered Jul 11 '14 at 13:05

Bruno Saraiva

11
1

score 0 · Answer 2 · answered Jan 24 '13 at 21:37

0

how about this?

s.replace(/\s+/g, ' ');

EDIT:

mystring = mystring.replace(/(^\s+|\s+$)/g,' ');

This will remove all spaces from the beginning or end of the string...

answered Jan 24 '13 at 21:37

Ofir Hadad

1,800
3
26
47

How to remove white spaces in google docs spreadsheet cells?

2 Answers2