Thread: Copying over only limited number of characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
VBA Noob VBA Noob is offline
external usenet poster
  
Posts: 26
Default Copying over only limited number of characters
Nearly there

Try =LEFT(A1,6)

VBA Noob
phuser wrote:
Hi

need the formula to bring over only 6 of the characters from 1 cell to
another,

I thought it was =Left (A1, [6]) but it doesnt work

what am I doing wrong?

Reply With QuoteReply With Quote