#1   Report Post  
Old December 12th 05, 05:11 PM posted to microsoft.public.excel.worksheet.functions
Arturo
 
Posts: n/a
Default Text Extract

Cell W3= Smith, Joseph
=LEFT(W3,FIND(" ",W3)-1) gives me the left text including “,”.
=RIGHT(W3,LEN(W3)-FIND(" ",W3,1)) gives me the last word in the string.
The end result I’m trying to get is “Smith, J”
Looking for a way to pull the first letter after the comma and concatenate
that into the left formula…
Direction appreciated.
Arturo

  #2   Report Post  
Old December 12th 05, 05:24 PM posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Text Extract

=LEFT(W3,FIND(" ",W3)+1)

--
Gary's Student


"Arturo" wrote:

Cell W3= Smith, Joseph
=LEFT(W3,FIND(" ",W3)-1) gives me the left text including “,”.
=RIGHT(W3,LEN(W3)-FIND(" ",W3,1)) gives me the last word in the string.
The end result I’m trying to get is “Smith, J”
Looking for a way to pull the first letter after the comma and concatenate
that into the left formula…
Direction appreciated.
Arturo



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
Text Wrapping JMB Excel Discussion (Misc queries) 0 July 29th 05 02:41 AM
How do I extract a date as text not the 1900 reference number Adam Excel Discussion (Misc queries) 3 March 23rd 05 06:04 PM
Autofitting a row Josephine Excel Discussion (Misc queries) 2 March 3rd 05 04:37 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM


All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017