Hello,
I have a report that is exported from SalesForce. In the first column the account name list the full account name, which I need to shorten to a simple name
For example, A1=Alabama Department of Transportation I'd like to have B2=Alabama
I searched the formula, but I don't think I'm using the correct terminology because I know this is an easy one.
Thanks in advance for any help.
Michael
I went with:
=LEFT(A2,FIND(" ",A2)-1)
This fails on two name states though. You could always just compare to an index of state names to call them out.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Try
=TRIM(LEFT(SUBSTITUTE(A3," ",REPT(" ",255)),255))
Life's a spreadsheet, Excel!
Say thanks, Click *
In your case this is very tough to create a formula for us. Because the short names aren't in the same place for each cell. You can use IF/ELSE with the formula suggested by daffodil11 to get the appropriate short name if you know all the pattern of your names.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks