Using IF to selectively trim cell content

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

Colin Hayes

Hi

I have a small puzzle.

I want to say that IF A1 starts with the word 'NEW' , then trim the last
24 characters from the content and replace with a full stop. Otherwise
put A1 as is.

Can someone help some code?

Thanks.
 
This should work as long as your cells A1 is more than 24 characters long
otherwise you will get an error
=IF(LEFT(A1,3)="NEW",LEFT(A1,LEN(A1)-24) & ".",A1)

Regards
Steve

"Colin Hayes" wrote in message

Hi

I have a small puzzle.

I want to say that IF A1 starts with the word 'NEW' , then trim the last
24 characters from the content and replace with a full stop. Otherwise
put A1 as is.

Can someone help some code?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Correction 5
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
VBA to select all cells with content 2
Select until blank row 8
Selecting all cells with content using a variable 3
Code to format cells on several worksheets 2
Satisfying several criteria 4
Trimming a cell down to 256 Characters 2

Back
Top