## How to replace a Space with a Hyphen in a Spreadsheet..

One easy way to replace any character with another, is to use the Find and Replace function, but that is not always suitable.

However, using a cell with a … Read the rest

## How to replace a Space with a Hyphen in a Spreadsheet..

One easy way to replace any character with another, is to use the Find and Replace function, but that is not always suitable.

However, using a cell with a … Read the rest

## Counting the Number of Times a Specific Character Appears In A Cell..

This will count how many times the letter ‘a’ appears
=LEN(a1)-LEN(SUBSTITUTE(a1,”a“,””))

This will count how many times the character ‘,’ (a comma) appears

## Counting the Number of Times a Specific Character Appears In A Cell..

This will count how many times the letter ‘a’ appears
=LEN(a1)-LEN(SUBSTITUTE(a1,”a“,””))

This will count how many times the character ‘,’ (a comma) appears

## How to Remove the LAST x characters from a cell..

Using the LEFT function we can tell Excel to take the value of one cell, remove a certain number of Characters from the Left, and return the balance

## How to Remove the LAST x characters from a cell..

Using the LEFT function we can tell Excel to take the value of one cell, remove a certain number of Characters from the Left, and return the balance

## How to Trim Leading and Trailing Spaces from Excel Spreadsheet Cells..

The TRIM function is easily used to remove both Leading and Trailing Spaces from Excel Spreadsheet Cells

The image below shows the use of =+TRIM(A1) in removing the space … Read the rest

## How to Trim Leading and Trailing Spaces from Excel Spreadsheet Cells..

The TRIM function is easily used to remove both Leading and Trailing Spaces from Excel Spreadsheet Cells

The image below shows the use of =+TRIM(A1) in removing the space … Read the rest

## I want to find data in an Excel sheet 2 that relates to data in sheet 1..

Sheet 1 column A contains various names.

Sheet 2 Column A contains all the names and column B contains a reference number for … Read the rest

## I want to find data in an Excel sheet 2 that relates to data in sheet 1..

Sheet 1 column A contains various names.

Sheet 2 Column A contains all the names and column B contains a reference number for … Read the rest