LinkBack URL
About LinkBacks
I have rows of text that I want to break after the first space in the text and only the first space. I don't see how to do this outside of a special macro and I can't write VBA... ideas?
I have rows of text that I want to break after the first space in the text and only the first space. I don't see how to do this outside of a special macro and I can't write VBA... ideas?
are there other delimiters or are you merely trying to split the text before and after first space ?
you could use formulae and split into 2 new cells...
A1: Mary had a little lamb
B1: =LEFT(A1,FIND(" ",A1)-1)
C1: =TRIM(MID(A1,FIND(" ",A1)+1,1000))
Is that viable approach for you ?
(Obviously once complete copy / paste special values the results over the formulae and then if necessary delete A or copy B:C to A:B and delete C)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
An alternative
=MID(A1,FIND(" ",A1,1)+1,255)
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks