Super easy question
All I am trying to so in use a formula
to take a name Martinez and leave all the charcter off except the M Please advise |
Super easy question
=LEFT(A1,1)
will give you the letter "M", whereas: =RIGHT(A1,LEN(A1)-1) will give you "artinez" Hope this helps. Pete On Nov 25, 4:23*pm, Dylan @ UAFC wrote: All I am trying to so in use a formula to take a name Martinez and leave all the charcter off except the M Please advise |
Super easy question
If you are looking for the first carachter of a cell, use:
=left(a2,1) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Dylan @ UAFC" escreveu: All I am trying to so in use a formula to take a name Martinez and leave all the charcter off except the M Please advise |
Super easy question
Dylan @ UAFC wrote:
All I am trying to so in use a formula to take a name Martinez and leave all the charcter off except the M Please advise Look in the help file for LEFT(). |
Super easy question
Hi,
The simplest you can use is =LEFT(A1) If this helps, please click the Yes button Cheers, Shane Devenshire "Dylan @ UAFC" wrote: All I am trying to so in use a formula to take a name Martinez and leave all the charcter off except the M Please advise |
Super easy question
Assuming that Martinez is in Cell A2, place this formula in cell B2
=LEFT(A2,1). this will extract the first character in a text. Does this do waht you want? Pls click Yes if this help cheers "Dylan @ UAFC" wrote: All I am trying to so in use a formula to take a name Martinez and leave all the charcter off except the M Please advise |
All times are GMT +1. The time now is 11:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com