Computeractive

Make Office Better

LIBREOFFICE CALC & MICROSOFT EXCEL

Move a specific number of characters to another cell

he MID function in Calc and Excel lets you move a set number of characters from one cell to another. You can use this to find characters that appear in the middle of a text string. In our example, we

You’re reading a preview, subscribe to read more.

More from Computeractive

Computeractive1 min read
Use An Old Laptop As Your Second Screen
At the start of this feature, we downloaded Spacedesk to our primary PC (or ‘server’ in Spacedesk terms). This server handles the sharing of the virtual display connection with a secondary device (called the ‘client’). So far, we’ve only used a phone
Computeractive5 min read
Phone and Tablet Tips
Google has updated its Photos app with a useful feature called Photo Stacks, which keeps your pictures better organised by grouping similar shots. Instead of showing multiple photos of the same subject, taken seconds apart, Stacks presents them as a
Computeractive2 min read
Should I Pay For…?
www.snipca.com/50048 Price: £49.99 per year Free trial: N/A What you need: Windows 7, 8.1, 10 or 11 Like all Icecream programs, PDF Editor packs lots of useful features into a simple, attractive interface you can master in minutes. But it also adopts

Related Books & Audiobooks