Edit whole column of cells

Using them, Making them , Finding them

Edit whole column of cells

Postby St3ph3n31 » Thu Jul 13, 2017 10:40 pm

Hi, I'm not sure I'm in the right place for answers as I'm relatively new to open office.

I've been forwarded a spread sheet , in column D it that's cells of data saying '£4 (for example) I need to remove the apostrophe in 1000+ cells , is there away I can remove the apostrophe in everyone with out going down every cell and manually removing it ?

Many thanks in advance for your time and advice.
Open office with 4.2.1 on windows
Posts: 3
Joined: Sat Apr 29, 2017 7:16 pm

Re: Edit whole column of cells

Postby robleyd » Fri Jul 14, 2017 2:41 am

Select the column of cells containing the data you want to change. Go to Data | Text to Columns; ignore the Separator options, check under Fields that Standard shows at the top of the displayed column (if not, click on the sample column and select Standard from the options list) and click OK

That should convert all the cells to Currency format.
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
Posts: 4151
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Return to Templates

Who is online

Users browsing this forum: No registered users and 2 guests