Thread: Select first 5 characters from another cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_527_] Leith Ross[_527_] is offline
external usenet poster
  
Posts: 1
Default Select first 5 characters from another cell

Hello Chris

The worksheet formula would look like this..

=LEFT($D$2, 5

This will return the first 5 characters of cell $D$2

Sincerely
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=50793

Reply With QuoteReply With Quote