Help for the formula

HI Rob,

Need small help on the this formula in (columns B), which is for read space but i have done up to 2 spaces only but when i m trying 3rd (Row A)
i m getting error or not reading.

formula is for trim & uppercase

Thanks,
LVL 1
M ZahidAsked:
Who is Participating?
 
ShumsDistinguished Expert - 2017Commented:
Hi Zahid,

Try below formula in B2 and drag down, if you want 3 words, change "3" as per your requirement:
=TRIM(LEFT(UPPER(A2), FIND("~",SUBSTITUTE(A2, " ", "~",3)&"~")))

Open in new window

0
 
M ZahidAuthor Commented:
0
 
ShumsDistinguished Expert - 2017Commented:
Hi Zahid,

Use below in B2 and drag down:
=TRIM(CLEAN(SUBSTITUTE(UPPER(A2),CHAR(160)," ")))

Open in new window

0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
M ZahidAuthor Commented:
this will read the whole thing from column A which may not required that's i was using to read it up to first spaces
0
 
ShumsDistinguished Expert - 2017Commented:
What are you trying to achieve? please post a sample with desired output with some more examples.
0
 
M ZahidAuthor Commented:
sir have u seen my attached file? i have mentioned in that file what i m looking for, plz advice if that is not clear?
0
 
M ZahidAuthor Commented:
Dear Shumas / Rob,

enclosed plz find file with the examples.

Thx
fromula-AML.xlsx
0
 
M ZahidAuthor Commented:
Thanks Shums, that is what i want to achieve :)
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.