How to match the 1st left word on diff sheet
Solved/Closed
Related:
- Diffsheet
- A little to the left free download mac - Download - Puzzle
- Google sheet right to left - Guide
- Left 4 dead 2 download - Download - Shooters
- Word apk for pc - Download - Word processors
- Number to text in word - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 9, 2011 at 08:50 AM
Aug 9, 2011 at 08:50 AM
Hi Cher,
You could use the text delimiter option (top menu > data). This will seperate your data where a space is found.
Best regards,
Trowa
You could use the text delimiter option (top menu > data). This will seperate your data where a space is found.
Best regards,
Trowa
Is there anyone who can help me with this?
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 16, 2011 at 09:54 AM
Aug 16, 2011 at 09:54 AM
It would help if you would comment on the replies, so we know what you don't like about it.
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Aug 12, 2011 at 01:52 AM
Aug 12, 2011 at 01:52 AM
If you don't want to use "text to decimal" option you can use this formula, it will helps you. for this you have to add one column in both sheets or you can use this in your Vlookup by addeding one column in your reference sheet only.
=LEFT(A2,FIND(" ",A2,1)-1),
"A2" need to be changed by your cell.
Regards,
Rahul
=LEFT(A2,FIND(" ",A2,1)-1),
"A2" need to be changed by your cell.
Regards,
Rahul
Oct 14, 2011 at 03:53 AM