Let's say the first client name was in A1, put this formula in B1 and
fill down as needed.

=LEFT(A1,5)

Don't forget to Copy/Paste Values to get the data hardcoded into your
worksheet.

HTH,
JP

On Jan 17, 4:44*pm, Mat wrote:
Dear mate,

I have 6000 client names and some are duplicates. I need to copy just the
first 5 letters of each client from the cell and place in the next cell. This
will help me to sum up all the ABCDE revenue as they are all same client with
different names with the first 5 letters are common.
Hope I was able to explain my issue,

For example

ABCDE Ltd
ABCDE co.
ABCDE inc
ABCDE ltee

Regards
Mat