Thread: Add text to a column based on text in a different column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Add text to a column based on text in a different column
Maybe...
=left(a1,3)
to take just the leftmost 3 characters.

Rick@Draper wrote:

I have a long column of 4 character letters that I would like to replace in
another column with 3 characters eg AAA1 to AAA. Is there any type of if
statement?

--

Dave Peterson
Reply With QuoteReply With Quote