I have a column with a general format that looks like this: "057828001 - WACS - Irving".
I need to remove the latter part of the value " - WACS - Irving"
I am doing that by using the replace all and typing in "-*"; that gives me a result of 57828001.
I need a result of 057828001.
How do I retain the leading zero?
If all the numbers are 9 digits: =MID(A1,1,9)
Or just do Data > Text to Columns > Delimited > and select Space or "-". Then just delete all columns but the one with the number in the beginning.
Let's pretend you have A1:
057828001 - WACS - Irving
Then, B1:
=TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",50)),50))
Copy down as far as needed
Then copy paste values
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!
WOrked like a charm! Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks